ISINSCOPE and HASONEVALUE functions in DAX and Power BI Desktop
ฝัง
- เผยแพร่เมื่อ 19 ต.ค. 2024
- In this video we look at working with totals in DAX and being able to identify the total row with the ISINSCOPE, HASONEVALUE and ISFILTERED functions.
I previously wrote a series of blogs on working with total rows that you can find on my website here:
mitchellpearso...
#MitchellPearson #MitchellSQL
I watched several videos on ISINSCOPE before this one, but you made the concept understandable. Thank you.
Please make more videos.
You are excellent in explaining complex concepts in simple manner.
Thank you for explaining this in such a way that I actually understand all three DAX measures!
A have been browsing tens of videos to understand ISINSCOPE function , your video is the best best with no comparison ... keep doing such amazing videos
Thanks a lot! Glad this video helped.
Brilliant explanation of a common source of confusion with DAX. Thank you!
Very good explanation of their differences!
Thanks MsOffice!
Thank you, it is really helpful for explanation.
Awesome- great coverage
Sir we need more of these in future pls continue
Excellent examples and explanations. But I have a problem working with Matrix visualisation and using 3-4 level grouping + calculating average values. At the row level everything is fine, but in the final totals and subtotals depending on the level of expanding madness happens. Examples with more complex situations that happen in a real environment would be great.
Thx a lot. Nicely explained
Mitchell, wonderful explanation as usual. Do you offer advanced DAX course? Thanks
Awesome...😃
Is your blog site active? I tried to subscribe but it continues to time out, via my computer and my phone.
Hey Gregory, I just had a co-worker do it and it seems a little tricky to follow. He clicked follow and then received an email and then he had to confirm the follow there! Sorry for the confusion.
@@MitchellPearson I think we're good now.