DAX Fridays!

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

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

50% 1

In today's video I will review a question I got on my youtube comments: How do I do cascading slicers in Power BI? Happy Friday!! #curbal #dax #daxfridays #powerbi
Links mentioned in the video:
SQLBI 1: www.sqlbi.com/articles/syncin...
SQLBI 2: www.sqlbi.com/articles/check-...
Get Northwind Dataset: • Northwind data source:...
Link to DAX Fridays survey: bit.ly/2MMM4KK
Here you can download all the pbix files: curbal.com/donwload-center
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

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

22 авг 2019

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@MrAszpic 5 лет назад

And there I was, using the 2nd option for big reports. Nice video, thanks for the optimization tip!

@CurbalEN 5 лет назад

Thanks SQLBI, they are the masters behind the trick! /Ruth

@MrAszpic 5 лет назад

@@CurbalEN True, I will start following their posts. Note on the integer thing, any mathematical operation would convert the true/false to 0/1. You could have multiplied the ISEMPTY by 1, easy peasy ;) EDIT: My bad, that's a trick we can use in Excel; Power BI needs the INT function to convert boolean (T/F) values to numeric ones (0/1)!

@CurbalEN 5 лет назад

Is that so? Thanks for sharing! Pin for more visibility :) /Ruth

@MrAszpic 5 лет назад

@@CurbalEN Oh, that's what can be done in Excel but it looks like PBI doesn't convert boolean to integer values with mathematical operations. Yes, the solution here is the INT function.

@CurbalEN 5 лет назад

Do you want me to unpin it or is it ok to leave it so people know? /Ruth

@ayobamiologun9184 5 лет назад

Thank you Ruth. Indeed very useful... Unfortunately, I've not had any opportunity (as in challenge) to put these things into practice. Anyway, I try to ensure I watch your videos to get myself prepared for the opportunity.

@leybourne 5 лет назад

Exactly what I was looking for! I couldn't find anything relevant and had to resort to the first and second methods last evening. And this morning, received the notification of this video. Thank you, Ruth! You are amazing! Wonder how I missed that Alberto Ferrari article!

@CurbalEN 5 лет назад

So much information, it is easy to miss! /Ruth

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

Thank you. The 3rd method is a super cool tip.

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

This is awesome! Thank you for explaining so well.

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

Thanks to you Sally for the feedback! /Ruth

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

That was awesome!!!!! I work with a Galaxy Schema and it works for me, really useful tip, you're one of my favorites youtuber ;)

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

Thanks Julian :) /Ruth

@chamilam 5 лет назад

Thanks Ruth for the great tips on INT. Didn't know it turns true and false to 1 and 0 either :)

@alejandrogonzalezbueno8044 5 лет назад

Buen video! Muchas gracias Ruth!

@CurbalEN 5 лет назад

A disfrutar del finde! /Ruth

@EricaDyson 5 лет назад

Another thing I didn't know and will definitely use! Thanks

@CurbalEN 5 лет назад

Happy Friday Erica! /Ruth

@EricaDyson 5 лет назад

And although you didn't know it, I had a many to many relationship which I knew I shouldn't do but couldn't think of another way (nothing to do with slicers). So you motivated me to look at this again and I solved the issue and now I have only one to manys... So a big thank you for that.

@CurbalEN 5 лет назад

That is great! Well done :) 🎉🎉🎉 (Proud teacher) /Ruth

@EricaDyson 5 лет назад

@@CurbalEN Ever so grateful student! Shabbat shalom as we say in this part of the world :-)

@vida1719 5 лет назад

It was interesting to learn that INT can convert true and false into numbers, I tested this in excel and it works there as well

@CurbalEN 5 лет назад

Great! Thanks for sharing! /Ruth

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

Hi I have a report where I have slicers for "Category" and "SubCategory". So, if I select a category in 1st slicer and then subcategory in 2nd slicer, I see the data. Now when I select a different category in 1st slicer, my 2nd slicer still have the Subcategory from old category. How do I make my 2nd slicer to "clear all" itself if I change the Category?

@RodWhiteley 5 лет назад

Great explanation of the trick Ruth - quick thing: "INT" is "Integer" (whole number) not Integral - don't think there are any calculus functions available in DAX :)

@CurbalEN 5 лет назад

😁😁😁 I meant integer, but sometimes my English comes out a bit ... how to say...Spanglish?Swenglish?? If you watched the correlation vs causation video, you will hear me say correlationships multiple times!!! 😂😂😂 My sincerest apologies to Mr Shakespeare. When I I say weird things in Spanish I apologize to Señor Cervantes😁😁 Happy Friday ! /Ruth

@pabeader1941 5 лет назад

Old trick. Excelisfun uses the int thing all the time. Might not even have to do int, might be able to do ANY math function to get a number from true false. Will have to test this.

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

Thanks!

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

And super thanks to you!!

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

Great 😊

@manliorolon3066 5 лет назад

thanks that were a real pain in the neck for a few projects.

@CurbalEN 5 лет назад

Thank SQLBI ;), they are the brains behind this ! /Ruth

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

In most programming languages you can typecast booleans (true/false) to integers. Because in memory itself 'true' is just a byte with a value of 1

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

AMAZINGGGGGGGGGGGGGGGGGGGG

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

Yeeeyyyyyyyyy!! /Ruth

@suemeagain 5 лет назад

NOT works like other Boolean operators, and it does not require a bracket between it and the target expression. That’s why you can write NOT ISEMPTY without the brackets.

@CurbalEN 5 лет назад

There you go! Thanks for the explanation :) /Ruth

@impala4641 5 лет назад

At 4.45 aprox. you said "Dependiendo what your calculation is" hehe Happens to me all the time! #spanglish Gracias for this video :)

@CurbalEN 5 лет назад

Did I? First I say integral instead of integer and now dependiendo? 😂😂😂 And all that without a drop of wine! I should get a Nobel price 😁 De donde eres? /Ruth

@impala4641 5 лет назад

@@CurbalEN You should!! jejej Soy de Bolivia! Power Bi está entrando de a poco aquí aún, tus videos son muy didácticos, nos ayudan a prepararnos a pedidos reales que pueden venir de un cliente en cualquier momento

@daniel.balandra 5 лет назад

Hey Ruth nice video! I have one question, in minute 8:53, is not easier to put the field 'Order Details' and select the option from the combo box "is not blank"?

@CurbalEN 5 лет назад

I explain that in the video, check it out again :) /Ruth

@daniel.balandra 5 лет назад

@@CurbalEN 😂 lol, so so sorry i just totally focus on the third option that i totally forgot about the second one. Ok but as u said the second option it could be not good because the complexity of the measure your are using, in this case "sales", so instead of using sales you used "order details" in the third option, but my question is, instead of making a new measure with the "int" and "not is empty" function and the measure "order details", can we use use the "order detail" measure in the filter pane with the option "is not blank" from the combo box of the filter pane? Because you still have do the calc of the measure your using, in this case the complexity was in the "sales" measure...

@CurbalEN 5 лет назад

Sure you can, depending on how your data and your model looks like you have those 3 options to the cascading. Happy Friday! /Ruth

@daniel.balandra 5 лет назад

@@CurbalEN thanks a lot, happy friday for you too! Wonderfull channel btw... Best regards