DAX Fridays!

[@MrAszpic]

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

[@CurbalEN]

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

[@MrAszpic]

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

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

[@MrAszpic]

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

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

[@mttwss]

Thanks!

[@CurbalEN]

And super thanks to you!!

[@leybourne]

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]

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

[@ayobamiologun9184]

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.

[@harinath4u]

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?

[@thaidude890]

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

[@cohjues]

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]

Thanks Julian :) /Ruth

[@RodWhiteley]

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]

😁😁😁 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]

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.

[@daniel.balandra]

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]

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

[@daniel.balandra]

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

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]

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

[@sallysproat8206]

This is awesome! Thank you for explaining so well.

[@CurbalEN]

Thanks to you Sally for the feedback! /Ruth

[@chamilam]

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

[@joaquimcosta952]

It's a way to solve it, but whenever we update the report, we have to put the filter back in! ?? In my case, I put a restriction on the dax formula.

[@vida1719]

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]

Great! Thanks for sharing! /Ruth

[@duckcluck123]

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

[@EricaDyson]

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

[@CurbalEN]

Happy Friday Erica! /Ruth

[@EricaDyson]

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]

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

[@EricaDyson]

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

[@suemeagain]

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]

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

[@alejandrogonzalezbueno8044]

Buen video! Muchas gracias Ruth!

[@CurbalEN]

A disfrutar del finde! /Ruth

[@Milhouse77BS]

Excellent post. I wonder if I could use INT in CALCULATE filters with TRUE/FALSE answers.

[@CurbalEN]

Try it!! And happy Friday :) /Ruth

[@manliorolon3066]

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

[@CurbalEN]

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

[@impala4641]

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

[@CurbalEN]

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]

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

[@kennethcandelaria6080]

INT is integer; quite sure. Function to get the integer, without the decimal :-)

[@chengwang411]

Great 😊

[@bahman7210]

AMAZINGGGGGGGGGGGGGGGGGGGG

[@CurbalEN]

Yeeeyyyyyyyyy!! /Ruth