How to add Measure Values To Slicer in Power BI to Slice and Dice your report? Can this be done?

[@thatgoanguy4427]

Wow. This worked. Thank you very much❤

[@ooizenming4381]

thank you, really help alot, calculated column have lead me to different value. This video save my time at least for few hour

[@workstuff5253]

A great way to start my week, with a great tip - delivered by you with brightness and happiness.

[@LighthouseAnalytix]

Glad you enjoyed it!

[@tomerweil]

Awsome, I just integrated into my project controlling dashboard, to filter project that are "On-Time" and "Delay". Thanks a lot!

[@LighthouseAnalytix]

Fantastic!

[@lucassudo9857]

that`s exatcly what i needed. thank you for sharing

[@shubhabratadey]

Awesome trick. Many thanks for this video

[@LighthouseAnalytix]

Glad you liked it

[@lucasrezende738]

Thank you for that! Really helped here!

[@LighthouseAnalytix]

Glad it helped!

[@Orlandolover01]

thank you so much, i hate circular dependency and this just saved me from having to spend another 2 hours dealing with circular dependency.

[@patrickharilantoraherinjat2994]

Brilliant. Thank you

[@ronaldpum]

Love your videos, especially the PowerBi. I am based in Adelaide and my employer is looking for a new CFO, it would be a dream to have someone like you onboard 🤩

[@LighthouseAnalytix]

Aw - thank you !!

[@嘤嘤嘤嘤嘤嘤-d7l]

Looking forward to your new episode😍😍

[@LighthouseAnalytix]

Very soon!

[@MasoudAlipoor]

Amazing, thanks a lot :)

[@mohammadghafaripour9465]

How about if the data comes from SSAS model and we dont want to add a table to our model?

[@jorgeandresrodriguez6729]

this activity function in kpis? or not

[@viethama9675]

How can i set measure slicer with multiple selection

[@dstorm2007]

Is it possible to slice based on an aggregate value from the original measure rather than having to create new categories through a new measure? i.e. Slicer that lets u filter the range of 'Diff_Amount'. So example, > 0$ but

[@thejavshow]

Is there a way to do something similar but with multi-select rather than single select?

[@LighthouseAnalytix]

hm... not sure yet. but thanks for giving me something to think about.

[@veranikakhilko1551]

It is possible. You don't need option "All" in your table then. And also DAX for measure Filter Flag should go something like this: VAR vSelected = allselected( Filter Classification[Selection] ) RETURN if([Classification] in vSelected, 1, 0)

[@Elo-i2h]

@@veranikakhilko1551 what if I have 3 or 4 selections and I want to cover all different combinations? 1 & 3 or 2 & 4 or 1 & 4...still searching for a solution

[@praneethvarma8208]

If measure returns a percentage value and can we use that measure in slicer? Tried multiple ways and if your answer is yes please make a video Thanks in advance

[@dream_merchant_4276]

Can you drop resource files in the comment? So we can learn by doing.

[@rakeshbhattacharjee2288]

Really good stuff..

[@megaherz2013]

Interesting, all of this to avoid using a calculated column.

[@LighthouseAnalytix]

yes - where possible, Measures are preferrable to creating calculated column in Power BI.

[@walterstevens8676]

It seems an incredibly long winded approach to what is a simple requirement...

[@Babayagaom]

Do you have better solution?

[@walterstevens8676]

@Babayagaom No.bi am not criticising the approach as such. I'm criticising why such an approach is needed.

[@Babayagaom]

@@walterstevens8676 because microsoft is busy with useless updates of visuals and not addressing actual issues

[@anirbandey9988]

Thanks a lot. Can i get ur number ?