How to hide empty rows that come from associations

[alenb]

USERS:
Load * Inline [
name, user_id
a, 1
b, 2
c, 3
]
;

EVENTS:
Load * Inline [
title, user_id
LaLa, 1
];

If I want to display all EVENTS with the data as below in the Table, it of course displays all the users, and their events if they have any. Now my goal is to not show the rows if a user does not have any associated event. I see two options:

1. Filter the USERS table in load phase by some kind of WHERE statement. 

2. Use a chart expression when adding user_id as dimension to the table.

For both of the above I don't know how to do it and I have searched around quite a bit.

[dplr-rn · Accepted solution]

basically you want to hide b and c rt.

if so in the table for dimension title disable 'Include null value'

[alenb]

It really was that simple 🙂