Filter out values based on other filter

[ezequiel]

Hi

I have a list of customers (20 customers) - Table A. I have another table with Customer that attended events, including the date of the event - Table B.

I'd like to display a list of customers that did not attend events, but this should be dynamically calculated based on a date filter. On the below, I need April and Caroline to be filtered out since they are on the first list. Note that the first list might change based on the Start date filter, reason why, the second list needs to change dynamically.

I'd appreciate your help on this,

Thanks

Ezequiel

[ezequiel]

Thanks @Samarth_18 . Almost there... I need the oposite. The output should be all, except for April and Caroline. Can you help me on the change? Thanks!

[Samarth_18 · Accepted solution]

@ezequiel Okay then change filter as below:-

[Samarth_18]

Hi @ezequiel ,

You can create a measure like below and use it as filter on your visual:-

Measure = COUNTROWS(FILTER('Table B','Table B'[Customer attending events] = MAX('Table A'[Customer])))

Output:-

Thanks,

Samarth