Forum Discussion
Calculated Measure's values into a slicer/report filter?
I have calculated measures and wanting to use that for a slicer/report filter.
I have two calculated measures "Best", "Next Best",
(Calculated measures solution: Solved: Re: Create new columns from other columns...)
I'm trying to create 2 filters (slicer) like below.
ex) If I select Toast in Slicer1_BEST, it will return rows that had "Toast" in the Best column (ex. Mearchant A and other columns)
ex) If I select Tea in Slicer2_NextBEST, it will return Merchant B and other columns)
Is this possible? Looks like PowerBI natively doesn't allow measures into slicers and I've tried adding parameter filters but dont think it was working properly. Any guidance is appreciated....!
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
All measures are in the attached pbix file's keymeasures field.
6 Replies
- Jihwan_Kim
Super User
Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
All measures are in the attached pbix file's keymeasures field.
- Jihwan_Kim
Hi,
Thank you for your message.
I am not 100% sure how your data model looks like, but if data model looks different, in some cases (I think in most cases), differnt measures have to be written.
- ribisht17
https://community.powerbi.com/t5/Desktop/How-to-use-a-measure-as-slicer/td-p/1726564
Based on your description, you can so some steps as follows.
Here is my test table.
I create two measures as follows.
Difference = MAXX('Measure_Slicer_test',[D2]-[D1])Status = IF(ISBLANK([Difference]),"Gray", IF([Difference]>0, "Green", IF([Difference]<0, "Red", "Amber")))1. Create a calculated table.Status =
var x1=SUMMARIZE('Measure_Slicer_test',Measure_Slicer_test[Product],"Status",[Status])
return
SUMMARIZE(x1,[Status])2. use "Status"[Status] to create a slicer.
3. create a measure, then drag it to the table visual of the original table and set the value as "1".
Measure_filter =
var x1=SELECTEDVALUE('Status'[Status])
return
IF(ISBLANK(x1),1,IF([Status]=x1,1,0))Result:
Hope that's what you were looking for.
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series
