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!
Any thoughts?