Forum Discussion
philseim
7 years agoFrequent Visitor
Matrix filter on a column values
Hi I have a matrix visual. I am trying to filter based on specific values based on the columns. There are about 20 different statuses. Users want the ability to select all values where the Intr...
Greg_Deckler
7 years agoCommunity Champion
In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
- philseim7 years agoFrequent Visitor
Thanks that's very useful. However in this case I need to select values so one column could be 0 and another column could be anything over 100. I need to do different combinations based on the column