DAX Fridays!

No video

DAX Fridays!

Рет қаралды 95,588

Күн бұрын

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:
1. SELECTEDVALUE: curbal.com/blo...
2. ALLSELECTED: curbal.com/blo...
3. IN: curbal.com/blo...
Here you can download all the pbix files: curbal.com/don...
Happy Friday!
Get Northwind Dataset: • Northwind data source:...
Link to DAX Fridays survey: bit.ly/2MMM4KK
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/cou...
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/...
▼▼▼▼▼▼▼▼▼▼
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:
curbal.com/pro...
Many thanks in advance!Here you can download all the pbix files: curbal.com/don...
▲▲▲▲▲▲▲▲▲▲
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#daxfridays #curbal #dax #powerbi #mvp

Пікірлер: 201

@silverwaters 14 күн бұрын

OMG I was trying to figure this our for hours! Thank you!!!

@avestuart 2 жыл бұрын

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.

@CurbalEN 2 жыл бұрын

Good luck with your project !!

@boul767355 4 жыл бұрын

Great Ruth, finally someone who can explain clearly PowerBI !

@CurbalEN 4 жыл бұрын

🥳🥳 /Ruth

@andrecavasotero6234 5 жыл бұрын

In my opinion the best part of the video was the explanation of the IN operator. Thanks for sharing.

@CurbalEN 5 жыл бұрын

Thanks Andre! It was a great example to explain it :) /Ruth

@Richkotite1 3 жыл бұрын

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

@CurbalEN 3 жыл бұрын

Glad to hear!!

@josecap12 Жыл бұрын

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.

@pradeepviv3672 5 жыл бұрын

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.

@CurbalEN 5 жыл бұрын

Thanks to you Pradeep for the feedback! /Ruth

@lawrencew8243 Жыл бұрын

Wow this solved my problem so quickly, spinning my wheels on different forums until I found this. Thank you!!!

@BrunoAraujo-po2lm 2 жыл бұрын

YOU'VE JUST SAVED MY WORKDDAY MAM, THANK YOU SO MUCH! Take my like and my subscription!

@CurbalEN 2 жыл бұрын

Welcome!! 🎉🎉

@Xarx42 Жыл бұрын

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! :)

@CurbalEN Жыл бұрын

Congrats, i completely understand the feeling :)

@awadelrahman Жыл бұрын

4 years old video, solved my problem today!!! THANKS

@CurbalEN Жыл бұрын

Fantastic and well done!! 👏👏

@juanignacioXI 4 жыл бұрын

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

@CurbalEN 4 жыл бұрын

We are probably working the same paths ;) /Ruth

@Unbox747 3 жыл бұрын

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

@CurbalEN 3 жыл бұрын

Music to my ears!!

@PeachBeef 4 жыл бұрын

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.

@CurbalEN 4 жыл бұрын

😂😂😂 Mine too!! /Ruth

@maraujjo 3 жыл бұрын

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

@CurbalEN 3 жыл бұрын

Yey!! Glad it helped!

@ravindrasarak2007 3 жыл бұрын

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

@pedrocapra4388 2 жыл бұрын

I was cracking my head, all I had to do was changing = to "IN". You rock!

@CurbalEN 2 жыл бұрын

🥳🥳

@andredeoliveira3684 Жыл бұрын

Thanks Ruth, you're the best! greetings from Brazil

@CurbalEN Жыл бұрын

Obrigada 😄

@paayumthotagaming8372 2 жыл бұрын

Thank you So much, you solved my 72 hours head scratching issue.

@yaga7406 2 жыл бұрын

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

@CurbalEN 2 жыл бұрын

And your feedback makes it all worth it, thanks!

@lxh3943 2 жыл бұрын

Thank you so much for all of your videos. You have helped me so many times. I appreciate you very much.

@CurbalEN 2 жыл бұрын

And Thanks for supporting me and my work, appreciate it too :)

@erichsanches823 3 жыл бұрын

Ruth, thanks a lot! You saved my day!

@roopalityagi3958 3 жыл бұрын

Thank you for making our lives easy :)

@CurbalEN 3 жыл бұрын

At your service ;)

@vedantdashora2528 2 жыл бұрын

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.

@navilese 3 жыл бұрын

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

@meghasyam427 11 ай бұрын

I have completed advanced dax course in udemy but they didn't give any basic explanation on allselected and selected value. But your 10 min video helped me understand basic intuition. Thanks a lot for your help.

@michelerampazzo 5 жыл бұрын

simple but very effective!!! Many thanks Ruth 👍!!!!!

@CurbalEN 5 жыл бұрын

Yey!!! The pleasure is all mine :) /Ruth

@user-cx9ji6ce6v Жыл бұрын

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

@bradj229 3 жыл бұрын

Outstanding! Thanks Ruth!

@theresakurtz2888 3 жыл бұрын

Thank you Ruth. I never knew about "IN". I used it to count the number of slicer items selected.

@CurbalEN 3 жыл бұрын

Yes, that is a great use case for IN, well done!

@rohitpuranikratlami Жыл бұрын

Thanks a lot for such a wonderful video🙏🏻🙏🏻

@sergegagne874 2 ай бұрын

You saved my bacon once again, thank you!

@tatuionut18 4 жыл бұрын

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

@CurbalEN 4 жыл бұрын

🥳 /Ruth

@HachiAdachi 5 жыл бұрын

Apparently you had already introduced us "IN" and "CONTAINSROWS" functions 79 DAX Fridays ago (#39), but I didn't remember even the existence of these functions until now. I guess it's time for a refresher... I'm afraid to find out what other useful functions I had forgotten but could have been perfect solutions for all these times that I was spending hours/days to come up with workarounds... but as they say, it's better late than never to learn (and re-learn... again...)! Thank you, Ruth!

@CurbalEN 5 жыл бұрын

Believe me DAX Fridays is a function refresher for me too and I check my old videos all the time!! Weird to learn from a past self 😂😂😂 /Ruth

@HachiAdachi 5 жыл бұрын

@@CurbalEN whoa, don't mess with the Space-Time Continuum, Ruth! That's some dangerous stuff! lol

@CurbalEN 5 жыл бұрын

😂😂😂 I knoooowww! /Ruth

@greatminds9315 Жыл бұрын

Big Thanks for the video and explanation, you are awesome. it saved my life. Subscribed :)

@CurbalEN Жыл бұрын

Welcome!

@mdupler1 4 жыл бұрын

Thank you soooo MUCH! I spent hours trying to figure this out!

@CurbalEN 4 жыл бұрын

🥳🥳🥳🥳

@poojachoudhury2227 2 жыл бұрын

just waooo.. This is what I was looking for exactly!!

@CurbalEN 2 жыл бұрын

Fab!!

@ahmedal-dossary4386 4 жыл бұрын

Awesome trick indeed Thanks for sharing your thoughts!

@rodrigofazzolari3466 3 жыл бұрын

Very ellegant solution. I was really stuck on that issue.

@gaurav6036 Күн бұрын

You are very blessed and i like your teaching I hope that I may get a life partner like you and for that I must also grow myself as deserving I am very unsocialized but blessed in indeed

@gaurav6036 Күн бұрын

Forgive me if I said something awkward because I am very unsocialized and do not know how to express anything appropriately

@ankushjain4128 3 жыл бұрын

Your session is full of informative .....please keep it up your work

@CurbalEN 3 жыл бұрын

Will do thanks!

@lucascolotta3315 2 жыл бұрын

Thanks, Thanks!!!!! You are the best! :D

@CurbalEN 2 жыл бұрын

You too 🎉🎉

@RajeevKumar-fm5xx 2 жыл бұрын

Awesome, great knowledge, exactly looking for that 👍

@ceobiclub9411 2 жыл бұрын

Thank you! Awasome!

@reggaegonza 11 ай бұрын

Love You!!!! from Argentina!

@hernanleandropanzini5089 3 жыл бұрын

Just what I needed, THANK YOU

@nielsrozeboom8852 3 жыл бұрын

This was of a great help for me. Thank you a lot!

@CurbalEN 3 жыл бұрын

🥳🥳

@jenniferchin3718 3 жыл бұрын

was struggling with a calc and this helped bridge the gap :) wonderful!

@CurbalEN 3 жыл бұрын

Yey!!

@excelrati 3 жыл бұрын

Thanks a million! This has been greatly helpful!

@CurbalEN 3 жыл бұрын

Yey!!

@navneetsingh1435 3 жыл бұрын

I was struggling on something simple for days and looks like a possible solution here.

@MaanEid 3 жыл бұрын

Thanks a lot! this is very clear and helpful

@selenevera8834 3 жыл бұрын

You save my life ! I love you ; )

@ecofriendlyify 3 жыл бұрын

Such a great trick. Thanks a lot!

@CurbalEN 3 жыл бұрын

Yey!!

@geobuenopaula 3 жыл бұрын

Thank you!!!

@TKLouie-ii2xh 4 жыл бұрын

Very good and very helpful, love it.

@bisjosc 4 жыл бұрын

thanks Ruth ..it is well explained and helps on my work .

@CurbalEN 4 жыл бұрын

Awesome to hear! /Ruth

@giri41 4 жыл бұрын

You are an Angel

@pabsmart 2 жыл бұрын

thanks a lot! I owe you one ;-)

@nedacil 4 жыл бұрын

simple and amazing

@CurbalEN 4 жыл бұрын

Really neat :) /Ruth

@LuisRomaUSA 3 жыл бұрын

Every single time management asks for some update that seems will take me hours of work, I come to your channel and find a soluiton that makes it minutes.

@CurbalEN 3 жыл бұрын

😊😊 Well done!

@vida1719 5 жыл бұрын

Magical In. Thanks for sharing

@CurbalEN 5 жыл бұрын

Neat function :) /Ruth

@alankarsrivastava5328 4 жыл бұрын

Thanks for wonderful information

@CurbalEN 4 жыл бұрын

Glad it was useful! /Ruth

@TheKantoni 3 жыл бұрын

Thanks for help

@aravinthkumar5001 4 жыл бұрын

This is very helpful. Thank you!

@mauriciopriego1700 4 жыл бұрын

Thank you for the trick.

@raneemalabwi2627 Жыл бұрын

Thank you for the great explanation. I have a question, Why didn't we put values instead of selectedvalue ?hank you

@summerbrooks7262 3 жыл бұрын

What if I wanted to select A, and always have B show as the constant comparison value as well as A or whatever else is selected? How could I do that?

@ginesc 2 жыл бұрын

Muchas gracias por la solución (varias selecciones en un slicer). ;-)

@myazigi 5 жыл бұрын

Excelente tip Ruth, muchas gracias!!!

@CurbalEN 5 жыл бұрын

Un placer y buen finde! /Ruth

@JesusCastro-fo6sn 5 жыл бұрын

Excelente, Ruth. Muy agradecido por tu aporte. Saludos.

@CurbalEN 5 жыл бұрын

Saludos y buen finde! /Ruth

@jonathanmartinez872 27 күн бұрын

Creeme o no, esto trate y no me dio la raza , ty hiciste maravillas ♥

@lucyesoque2614 5 жыл бұрын

THANKS! YOU ARE MY IDOL =D

@CurbalEN 5 жыл бұрын

Thaaaanks 😊 /Ruth

@jerrykappa6899 5 жыл бұрын

Nice one... never used IN before but I sure will. 😁

@CurbalEN 5 жыл бұрын

Neat little function 😊! Happy Friday :) /Ruth

@diegoortega1138 4 жыл бұрын

This very good! Thanks.

@CurbalEN 4 жыл бұрын

You welcome!

@patrickkinbonso1809 9 ай бұрын

Interestingly when you click A and B on your filter, it said 200 and 500 which shows only the inter-filter from your category table (which has chosen only category B). As a result it confuses me a little whether your slicer in effect works but I trust that it does.

@kavyakovuru9 2 жыл бұрын

Hello mam, this video has the relative information of what I'm searching today, Just one question, can we display more than 2 values using the same DAX function? Thanks in advance!!

@mamdll007 Ай бұрын

Thank you for your video. It was very clear. I have a question, please. If the user wants to filter on a visualization dimension (slicer) that concerns several columns. In advance, I wonder on which column I should add the dynamic filter condition based on the user’s choice. Example : Dimension de visualisation 2'[Categorie] -> Categorie contains the name of three different columns var selectcategory = SELECTEDVALUE('Dimension de visualisation 2'[Categorie]) return CALCULATE([Taux de complétude Linky], FILTER (NRJ_TRAFIC_PUISSANCE_MOIS, NRJ_TRAFIC_PUISSANCE_MOIS[selectcategory]) = "") thank you in advance for your return

@dhruvsingh9 3 жыл бұрын

Thank you so much for this .... Can you show us the same with date slicer... Where I have a period in the slicer like fromdate and to date kind of situation

@JitendraSingh-pg9sc 2 жыл бұрын

Love your video Ruth, I am looking for some help. I am using date range slicer and on every selection I want to filter my page (filter chart and table data) for the selected date range and it should also include data for blank date values as well every time.

@ChrisSmithFW 2 жыл бұрын

This is great. Thanks so much. Just one question: what do we do with the Category card that returns blank when multiple values are selected?

@leonardoolivaro5230 3 жыл бұрын

You are amazing !!!! take a not: values in the slicer selected must be in text format otherwise returns an error. I was making that mistake :(

@CurbalEN 3 жыл бұрын

It is always the little things…

@djeritorres 5 жыл бұрын

Hola Ruth. 7:10 el rostro cuando DAX no obedece... Me ha sacado una risa. Saludos

@CurbalEN 5 жыл бұрын

😂😂😂 Quizás debería editar más los vídeos para no daros esos sustos !! 😂😂 /Ruth

@Himanshu_Yaduvanshi04 2 жыл бұрын

What if we can take out the unique categories from the orders table to make the slicer and filter the table with that slicer?

@bhuruu 3 жыл бұрын

This is super . However in this case we have only 1 measure or same style of measure (ony filter condition was changed). How about when we have different measures ?

@srikiranakula5170 4 жыл бұрын

Hi Ruth, I likes your videos on DAX... Could you pls make a video on Selectedmeasure(), IsSelectedmeasure()

@metricosavante6551 4 жыл бұрын

Excelente aporte muchisimas gracias. Me encuentro con un escenario similar pero no me da el resultado esperado, mas bien, no obtengo ningun resultado, solo error. Mi ejercicio es con un slicer de fechas (donde elijo un inicio y un fin) lo que necesito es, tanto de la fecha inicio como fin, identificar el año y el mes para posteriormente saber cual es la meta TOTAL de ese Mes&Año y no solo de los días que apliqué en el filtro

@CurbalEN 4 жыл бұрын

Hola! La comunidad de power bi es el sitio perfecto para este tipo de preguntas, pruébalo! /Ruth

@brunelresidences1113 5 жыл бұрын

Great video Ruth - wondering, how can the card show the multiple values selected i.e. A, B, C rather than Blank?

@CurbalEN 5 жыл бұрын

A card can only show one value. To show more you can use a table instead :) /Ruth

@jaeesteban2850 3 жыл бұрын

you videos are great! have a question though? What if I have 3 slicers? Can I still use this?

@arghyadutta9091 6 ай бұрын

Great

@shahpashupati Жыл бұрын

Nice Video but what to do if I want the sum of total amount for category B even if category A and B are selected. Thanks in advance for your response.

@hello-u2w 4 жыл бұрын

This is great, but is there a way to do this with the slicer column being in the same table as the measure? Cause this is kinda silly to be honest

@MuhammadAbdulSami-p3k Күн бұрын

Thanks for this video, but this functionality is not working with the date slicer. I want to calculate date difference in days by comparing selected date of slicer. If anyone have solution then please let me know, and now as workaround i am using query parameter.

@thetoediastv Жыл бұрын

Hi, thanks for your video. I have a question. I have 3 stages, Concept, Plan and Execution, for my project, I have put them in a filter in excel, now currently all activities are in the Concept stage, I want to show all the stages on the dashboard even though at present all activities are in the Concept stage, I want the dashboard to show all the other stages. I tried the option "Show all items with no data", but that doesn't work, any help please, thanks

@EngineeredFoodies 2 жыл бұрын

I have an issue. I wanted to calculate the lowest value in a column for each year. Using the min implicit function I am able to get the minimum value. But when I put this on an animated bar chart, it displays all the minimum values of that particular year. Whereas, I wanted the lowest value per year to be displayed. Here is the code in DAX which I tried but the result is the same: Lowest per year = MINX (FILTER ( Dates, Dates[Year]), MIN('Score board'[Lowest Total.Score] ) )

@sumedtare827 2 жыл бұрын

Will take your case only I need to show Slicers selection When selected A show 0 When selected B show 0 When selected A and B show 0 When selected C show C value When selected C and other show C value Much appreciate on your support

@malavikamenon9127 10 ай бұрын

I want to auto fill/ select the value of a multi-select slicer based on another integrated slicer. Is that possible?

@mariaBI129 3 ай бұрын

Hi, how do you show default value when there is no selection?

@eddyjawed4871 2 жыл бұрын

This is great but I was looking for a simpler way to filter data without a sum calculation. Is such a thing possible? For example I want to filter a list of months from current period to start of the year (YTD) using a slicer?

@hemanadezhdank401 2 жыл бұрын

Is it possible to assign the selected value dynamically to pull in different column values. Say, YTD, MTD, QTD as the selected value in the slicer and they are the separate columns in time dimension. Then how is it possible to pick the YTD, MTD, QTD flags from time dimension table. Please suggest.

@manu053299 2 жыл бұрын

I have 2 silters on 2 different columns, but when I use selectedvalue, Dax seems to get confused from which coumn to pull the data from... do you have a solution?