Forum Discussion
Filter by values NOT selected
I can see instances (other than this particular example) where having the ability to filter by values NOT selected can be useful so perhaps this will be a future add for the BI team?
I see what you are trying to do with the measure but it is not working on my end.
Model Layout:
1) Dimension Table "*Applications" - Contains all unique values of "Application" column of the fact table titled "Report".
2) Fact Table "Report" - is linked via many-to-one relationship to the "*Applications" dim table ( 'Report'[Application] *-->'*Applications'[Application] )
Report Page:
Have a slicer based on the '*Applications'[Application] column
Have a table visual showing 'Report'[Computer] and 'Report'[Application] columns.
Measure titled "Visual Filter" placed on the table visual noted above, with criteria of "Show items when the value: ... is ... N. The measure has the following syntax:
The intent of only displaying values not fitting the measure return criteria "N" (unselected values) is not working as implemented above. Let me know if there is something I am missing.
Thanks!
Hi igaca ,
You need to use measure on visual level filter to filter 'Y' result. My formula will extract opposite records of selection and compare with current row contents to return tag.
If you confused how to use it, please provide a pbix file with some test data, then I can build a sample file to share.
Regards,
Xiaoxin Sheng