No video :(

DAX Fridays!

Подписаться 135 тыс.

Просмотров 95 тыс.

50% 1

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/blog/glossary/sele...
2. ALLSELECTED: curbal.com/blog/glossary/alls...
3. IN: curbal.com/blog/glossary/in-dax
Here you can download all the pbix files: curbal.com/donwload-center
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/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
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/product/sponsor-me
Many thanks in advance!Here you can download all the pbix files: curbal.com/donwload-center
▲▲▲▲▲▲▲▲▲▲
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

Опубликовано:

7 мар 2019

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 197

@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

@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.

@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

@ahmedal-dossary4386 4 года назад

Awesome trick indeed Thanks for sharing your thoughts!

@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!!

@ravindrasarak2007 3 года назад

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

@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

@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!

@navilese 3 года назад

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

@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!

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

@erichsanches823 3 года назад

Ruth, thanks a lot! You saved my day!

@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

@tatuionut18 4 года назад

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

@CurbalEN 4 года назад

🥳 /Ruth

@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.

@bradj229 3 года назад

Outstanding! Thanks 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

@michelerampazzo 5 лет назад

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

@CurbalEN 5 лет назад

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

@hernanleandropanzini5089 3 года назад

Just what I needed, THANK YOU

@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!

@jenniferchin3718 3 года назад

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

@CurbalEN 3 года назад

Yey!!

@andredeoliveira3684 Год назад

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

@CurbalEN Год назад

Obrigada 😄

@aravinthkumar5001 4 года назад

This is very helpful. Thank you!

@sergegagne874 2 месяца назад

You saved my bacon once again, thank you!

@TKLouie-ii2xh 4 года назад

Very good and very helpful, love it.

@lawrencew8243 11 месяцев назад

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

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

@user-cx9ji6ce6v Год назад

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

@meghasyam427 10 месяцев назад

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.

@ankushjain4128 2 года назад

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

@CurbalEN 2 года назад

Will do thanks!

@JesusCastro-fo6sn 5 лет назад

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

@CurbalEN 5 лет назад

Saludos y buen finde! /Ruth

@myazigi 5 лет назад

Excelente tip Ruth, muchas gracias!!!

@CurbalEN 5 лет назад

Un placer y buen finde! /Ruth

@RajeevKumar-fm5xx 2 года назад

Awesome, great knowledge, exactly looking for that 👍

@BrunoAraujo-po2lm 2 года назад

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

@CurbalEN 2 года назад

Welcome!! 🎉🎉

@mdupler1 4 года назад

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

@CurbalEN 4 года назад

🥳🥳🥳🥳

@nielsrozeboom8852 3 года назад

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

@CurbalEN 3 года назад

🥳🥳

@MaanEid 3 года назад

Thanks a lot! this is very clear and helpful

@excelrati 3 года назад

Thanks a million! This has been greatly helpful!

@CurbalEN 3 года назад

Yey!!

@rodrigofazzolari3466 3 года назад

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

@bisjosc 4 года назад

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

@CurbalEN 4 года назад

Awesome to hear! /Ruth

@reggaegonza 10 месяцев назад

Love You!!!! from Argentina!

@pedrocapra4388 2 года назад

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

@CurbalEN 2 года назад

🥳🥳

@greatminds9315 Год назад

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

@CurbalEN Год назад

Welcome!

@rohitpuranikratlami Год назад

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

@awadelrahman Год назад

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

@CurbalEN Год назад

Fantastic and well done!! 👏👏

@selenevera8834 3 года назад

You save my life ! I love you ; )

@vida1719 5 лет назад

Magical In. Thanks for sharing

@CurbalEN 5 лет назад

Neat function :) /Ruth

@paayumthotagaming8372 2 года назад

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

@roopalityagi3958 3 года назад

Thank you for making our lives easy :)

@CurbalEN 3 года назад

At your service ;)

@poojachoudhury2227 2 года назад

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

@CurbalEN 2 года назад

Fab!!

@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?

@ceobiclub9411 2 года назад

Thank you! Awasome!

@ecofriendlyify 3 года назад

Such a great trick. Thanks a lot!

@CurbalEN 3 года назад

Yey!!

@mauriciopriego1700 4 года назад

Thank you for the trick.

@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.

@lucascolotta3315 2 года назад

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

@CurbalEN 2 года назад

You too 🎉🎉

@alankarsrivastava5328 4 года назад

Thanks for wonderful information

@CurbalEN 4 года назад

Glad it was useful! /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

@jerrykappa6899 5 лет назад

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

@CurbalEN 5 лет назад

Neat little function 😊! Happy Friday :) /Ruth

@jaeesteban2850 3 года назад

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

@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

@giri41 4 года назад

You are an Angel

@geobuenopaula 3 года назад

Thank you!!!

@raneemalabwi2627 11 месяцев назад

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

@lucyesoque2614 5 лет назад

THANKS! YOU ARE MY IDOL =D

@CurbalEN 5 лет назад

Thaaaanks 😊 /Ruth

@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!!

@diegoortega1138 4 года назад

This very good! Thanks.

@CurbalEN 4 года назад

You welcome!

@navneetsingh1435 3 года назад

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

@olivierriss 4 года назад

Thank you for your so useful videos ! I used your tip in this video on Power BI, it works perfectly ! But... when I write the same dax measure in Excel / Power pivot, I get a syntax error message about the "in" :-( Have you an idea why I can't use it in Power Pivot ?

@nedacil 4 года назад

simple and amazing

@CurbalEN 4 года назад

Really neat :) /Ruth

@TheKantoni 3 года назад

Thanks for help

@vivekvarma1038 4 года назад

Nice! I kinda have a similar scenario, could you help me out here? I have a Table1 with two columns: Employee Name and their Joining Date and Table2 with just dates for a user to select from a dropdown. Can I use the selected date from the user and compare it with the Joining dates in Table1 to create a flag (to check if the employee joined in the selected month or before the selected month) ?

@just4fun410 5 лет назад

Hi Curbal, If we don't select any value from slicer can we get aggregated value like (1500) without displaying category in the same table. If it's possible kindly let me know. Thanks :)

@ginesc 2 года назад

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

@srikiranakula5170 4 года назад

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

@cliveluis 4 года назад

Great video ,Hi I have a question in reverse , what if I multi select 3 months and do not want YTD for certain columns/Values (ie addition of 3 months)? For Example , I’m ok with YTD for revenue by Multiselecting but for some other values , I want position at end of month Example if I select jul aug sep , I want YTD for revenue which is fine and normal , but for some other columns I want values at end of August only ( not total of July aug sep) ?

@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?

@pabsmart 2 года назад

thanks a lot! I owe you one ;-)

@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!

@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?

@bellalee9703 3 года назад

Hi. this video is so helpful. I'm working on designing a dashboard in power bi. I want a user click on the slicer by name of project title. For example, the user click project A in the slicer. As a result, the graph will show that project A's progress for all months (Jan-Dec). Otherwise, if the user is not clicking the slicer, the graph remains blank. how I'm supposed to do? Thank you.

@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

@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.

@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

@subhadeepsarkar6402 3 года назад

Hi I have a question , currently i am making a card where user will select a particular year and month and the value of a particular measure for that year and month will be shown in card please tell me how to put multiple condition inside selectedvalue from multiple column from filter?

@bahman7210 4 года назад

Thank you Ruth . i have question , i need to show report base on employee name or employee id so for that reason i create new table to show name/employeeid in drop down ( SelectTbl) and based on selected value i wrote new formula to create column newcolumn= if( SelectTbl[AnonymousSelected] = "name" , Employee[name] , Employee[ID] ) but it doesn't work . (seems formula doesnt work for column and it just work for measure ) so instead of adding new table , if new fake column added to Employee table and change formula to newcolumn= if( Employee[AnonymousSelected] = "name" , Employee[name] , Employee[ID] ) then it works! :( do you have any idea why powerbi is so lazy !?!(disappointed ! you can do whatever you want in tableau but ....)

@erikcrins 2 года назад

Hi This is the first time I see one of your video's. Thank you for taking the time and effort! Great solution! But... What do I need to change if I want this to work with a slicer that has tekst in it? Id like to show the selected strings in a card. (I have slicers on the first page of a report(synchronised for all other pages) and I'd like to show the selections on the pages with visuals)

@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.

@shayandossani91 4 года назад

I have one issue. I have 2 dates col in one table. I want to calculate MTD from date 1 and I want to use filter for date 2 column to get MTD for Date 1 values when filtered any specific month. How it could be possible?

@eddyjawed4871 Год назад

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?

@malavikamenon9127 10 месяцев назад

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

@ADFTrainer 4 года назад

If I don't want select a,b,c , table measure should blank. Can any one help on it

@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 ?

@franklynjandozo2610 5 лет назад

Muito bom!

@CurbalEN 5 лет назад

Obrigada :) /Ruth

@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?

@denisedff 5 лет назад

Hi Ruth great because it is guiding me to the right direction. But I was wondering. What if I do not need to calculate, if I wanted filter the information from a table where selectedvalue >= column A and selectedvalue

@CurbalEN 5 лет назад

The error is telling you that your Measure returns a table when only a value is allowed. Different solutions depending on what you are trying to do. Can you post in the power bi community, giving all the details? /Ruth

@mamdll007 10 дней назад

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

@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.