Forum Discussion
Resolver IFilter by a measure
Hi folks, I have one table with 2 measures
"Total Revenues" , "Total Budget"
I have a 3rd measure that prints "OK" if the first 2 columns have the same value otherwise prints "KO" if Total Revenues" <> "Total Budget".
Works fine, but I can't insert a Slicer Filter to filter only rows with "OK" (or "KO") values
Any suggestion is appreciated.
Thanks,
We can't directly put a measure into a slicer since the measure need to be sliced to get the corresponding data. In your scenario, you can create a calculated table and build those measures into calculated column, then you can use apply slicers on these columns.
Calculated Table = ADDCOLUMNS( Table, "Purchased",CALCULATE(SUM('Fact Purchase'[Ordered Quantity])), "Sales",CALCULATE(SUM('Fact Sale'[Quantity])), "_meas", IF([Purchased]=[Sales];"OK";"KO") )Regards,
Simon Hou
9 Replies
- MattAllington
Community Champion
You can't put a measure as a slicer choice. You could try adding a bar chart with the 2 text items on the axis and count as the value. Then try clicking the bars
- pceglie
Hi, thanks for your reply
"You could try adding a bar chart with the 2 text items on the axis and count as the value. Then try clicking the bars"
What do you mean with "with the 2 text items on the axis"?
I'm not able to add the 3rd measure as AXIS in a bar chart
- Greg_Deckler
Could you supply some sample data (as text, not screen shot) and your measure calculations so that the problem can be recreated? See this post:
http://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
