Forum Discussion

ezequiel's avatar
ezequiel
Microsoft Employee
4 years ago
Solved

Filter out values based on other filter

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

Need Help

3 Replies

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    4 years ago

    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

     

  • ezequiel's avatar
    ezequiel
    Microsoft Employee
    4 years ago

    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!