DAX for Power BI Part 4.4 - Using Variables

[@sosophrank]

Thanks

[@wayneedmondson1065]

Awesome Andrew! I've always wanted to gain a better understanding of using variables in DAX. Your explanations are clear and easy to follow. Thanks a million! Thumbs up!!

[@WiseOwlTutorials]

Thanks Wayne, happy to hear that you enjoyed it!

[@tejamarneni]

Thank you, Andrew. This is what I was waiting for.

[@WiseOwlTutorials]

You're welcome Teja, thanks for watching!

[@mePrafull]

Thank you very much for the detailed explaination of varaibles, very much helpful.

[@WiseOwlTutorials]

Thank you so much for watching!

[@ericbrenner690]

Another excellent tutorial!!!

[@WiseOwlTutorials]

Thanks Eric, glad you enjoyed it!

[@saadahmedqureshi1156]

Very well explained. Thank you so much.

[@WiseOwlTutorials]

You're very welcome, thanks for watching!

[@infamous8541]

thank you Mr owl 🦉

[@WiseOwlTutorials]

You're welcome, thanks for watching!

[@qasimali-gu3oz]

19:29 I was expecting FILTERS instead of CALCULATETABLE. Can you explain why can't we use FILTERS here instead of CALCULATETABLE?

[@WiseOwlTutorials]

Hi! We could have used the FILTER function here, I just chose to use CALCULATETABLE instead. You can find a later video in the playlist which explains the differences kzbin.info/aero/PLNIs-AWhQzclPj5BGcckuyrOVqRD-7rIX&feature=shared I hope it helps!

[@nikakalichava8012]

Hello! Thank you again, but I got a little confused at 20:26. So SUMX has 2 arguments 1 - TABLE and 2 - EXPRESSION. As First argument "TABLE "we use CALCULATETABLE, an expression... And as second argument of "EXPRESSION" we used a column?? Am I missing anything? How come? EDIT*: I feel like the measure should b like this : VAR Budget = SUMX( CALCULATETABLE( Movies, NOT ISBLANK(Movies[Box Office]), NOT ISBLANK(Movies[Budget]) ), SUM(Movies[Budget]) ) How can we use a column as an EXPRESSION argument?

[@WiseOwlTutorials]

Hi Nika! A column reference is an expression, albeit a simple one. You don't need to insert a SUM function into a SUMX function because SUMX already sums the values returned by the expression argument. A basic SUM function is just a SUMX function in disguise. When you write: SUM(Movies[Budget]) It is translated to: SUMX(Movies, Movies[Budget]) I hope it helps!

[@nikakalichava8012]

@@WiseOwlTutorials Yeah clears out. Thanks!

[@mydreams7104]

Sir I couldnt join your channel. It shows me error.

[@jerrydellasala7643]

This excellent video inspired me to join to get access to the rest of this playlist. I had almost done it the last time you made one available to non-members, but just didn't pull the trigger. Anyway, I'm still stuck on this one. The rest are unavailable, even the ones listed in the Members section. I joined at the chick level. Do I need to upgrade, or does it just take a while for it to kick in? Seems to be OK on the Members page. Thanks for some great videos!

[@WiseOwlTutorials]

Hi Jerry, thanks for choosing to support us! At the moment you're showing as having joined at the Egg level which doesn't provide access to members only videos, rather than the Chick level which does. There's some support documentation here which I hope will help support.google.com/youtube/answer/6304294?hl=en&co=GENIE.Platform%3DDesktop#zippy=%2Cchange-your-membership-level

[@jerrydellasala7643]

@@WiseOwlTutorials Thanks for the quick reply. Upgraded. I really like your stuff!

[@AmitSharma-po1zb]

Hey Andrew, I am getting a VBA error "method open of object Recordset" failed to connect..there's an SQL statement written to open a SharePoint but it's not working..need ur expertise here pls

[@nelrosell1]

we can also do like this OR(ISBLANK(Movies[Box Office]),Movies[Budget]) as it's only two values are evaluated rather than using two pipes || for OR condition

[@WiseOwlTutorials]

Indeed you can! kzbin.info/www/bejne/gX_XZoF_atB0mMkfeature=shared&t=1207 Although you need to include the ISBLANK function for Budget as well as for Box Office: OR( ISBLANK(Movies[Box Office]), ISBLANK(Movies[Budget]) ) Personally, I prefer pipes because they work regardless of how many conditions you're using, while OR only works for two conditions.

[@jaichander87]

Hello sir! Is it a good idea to use VBA code (similar to vlookup) on excel file containing 5 lack rows?

[@stickercode]

Mostly lost in the last 5 minutes. I think, I need to take a break since watching 3 videos in row causes headaches

[@WiseOwlTutorials]

I found DAX to be a language which reveals its secrets slowly!