Forum Discussion
Help with project
ephramz That's because you have some other measure that is returning a value so the row is going to get displayed. If you don't want that to happen you can basically take the same exact formula in a new measure that returns 1 or 0. So:
Selector = VAR __WhatToShow = SELECTEDVALUE('Table31a'[Column]) VAR __Value = MAX([Arising]) * MAX([Delta]) RETURN SWITCH(__WhatToShow, "positive",IF(__Value>0,1,0), "negative",IF(__Value<0,1,0), "zero",IF(__Value=0,1,0), 1 )You use the Filter pane to filter on this measure is 1. This is called a Complex Selector. The Complex Selector - Microsoft Power BI Community
I feel like I've solved 12 problems in one thread.
Greg_Deckler
Okay, then based on my measure "Arising* Delta" measure which has positive and negative values, how can i create a slicer than can show only "positive values", "negative values", "blank values" and "values that are zero"
ephramz You would use the disconnected table trick. 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