DAX Fridays! #118: Get selected or multiple values from slicers using DAX

In today's #daxfridays video I will show you how to get selected or multiple values from a slicer.
To do that, we will use the following functiions:

Happy Friday!

SUBSCRIBE to learn more about Power and Excel BI!

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

▲▲▲▲▲▲▲▲▲▲

Our PLAYLISTS:

************

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#daxfridays #curbal #dax #powerbi #mvp

[pradeepviv]

Thanks very much Ruth, this has been very useful. I love how your video is simple to understand and follow. Also thanks very much for your community PBIX files. Cant wait to check it out.

[josecap]

Thanks so much for sharing this solution. I spent hours trying to figure it out in a situation with filters of different time periods on the same column, and it helped me to avoid duplicated sum.

[ahmedal-dossary]

Awesome trick indeed

Thanks for sharing your thoughts!

[Richkotite]

This for me was the best and most important DAX Power Bi video I have seen. M management likes to look at selective items. This one did it, works great. Thank you

[PeachBeef]

Haha the end there where you got turned around, welcome to half of my day at work! I love your videos so much, you've taught me so so so much.

[Unbox]

I love your videos. It's always so inspiring, it just gave me an idea to solve something that was considered unsolvable.

[vedantdashora]

That’s amazing! You saved my 2 months of PBI efforts to get rejected just because of I couldn’t figure out how to do this requirement applied over.

[avestuart]

Oh my god, this is a lifesaver. I have a very odd dataset and up against a serous deadline, being able to get selected values from a slicer and then send variables to a dataset based upon those slicer values is incredible.

[Xarx]

I just spent quite some time to figure out how to select multiple(!) options and not just one until your video pushed me finally in the right direction. Thank you a lot! :)

[juanignacioXI]

Ruth u have always the answers for all my Dax problems, hehe, thanks a lot a gain. You r the greatest teacher ever!

[ravindrasarak]

This helped me a lot. Thank you so much. IN Function is magical!

[yaga]

Thanks a lot - I was able to solve many of my problems/questions with you videos. Really appreciate the time you spend sharing!

[erichsanches]

Ruth, thanks a lot! You saved my day!

[navilese]

Thanks you!! I was needing this solution, and after a whole day of working I got it becouse of you :)

[tatuionut]

Awesome! Exactly what I was looking for!
Thank you!

[maraujjo]

Great!! I was searching for a week trying to solve this!! You are amazing! Thank you so much!!

[boul]

Great Ruth, finally someone who can explain clearly PowerBI !

[cxjicev]

Awesome. Thanks a lot, this is exectly the solution I wanted googling how to get list of selected values from a slicer)

[myazigi]

Excelente tip Ruth, muchas gracias!!!

[michelerampazzo]

simple but very effective!!! Many thanks Ruth