Forum Discussion
Anonymous
2 years agoNot applicable
Slicer Using Measure Based on Criteria
Hi, Is it possible for a slicer to accommodate a measure based on criteria e.g. the screenshot showed criteria for Negative Variance, Negative Variance with No Sales, etc? //NT ...
hnguy71
2 years agoSuper User
Hi Anonymous ,
Assuming that the comments within your measure are derived by a logic, yes.
Let's assume you have a comment measure with something similar to this:
You'll need to create a disconnected slicer table that holds the same value. For example:
Next, you'll create a measure to determine which row you should keep:
Finally, add a filter on your table by filtering the measure for the value of 1.
To see it in action: