Forum Discussion

ezequiel's avatar
ezequiel
Icon for Microsoft Employee rankMicrosoft 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 customer...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    ezequiel Okay then change filter as below:-

     

     

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity 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