Distinguishing HASONEVALUE from ISINSCOPE 

I'm a PowerBI profession in Turkey. Spend more than a full year just on PowerBI. I follow like about 10 channels in youtube and only you always have the solutions for my toughest problems. You rock !

Excellent video , loving the fact that you are teaching the difference and also the impact on performance using one or the other. Keep content like this coming please !!!!

Very helpful videos! Correct length, clever and easy examples. It is obvious that you try to find the best way to transfer your knowledge. Thank you very much once again for your efforts!

Thanks Alberto, great stuff as usual. Good to know that ISINSCOPE relies on visible values in the visual.

This is just an awesome explanation i have ever seen. you're a champion @Alberto.

Really like this format of relatively short focused videos that cover well just one small aspect of DAX. In a year or two this series could amount to a nice companion to any DAX learning process. Btw, I think the example with RANKX gave me a hint related to an issue I had with using dense RANK vs skip RANK. Dense was returning correct results, while skip seemed to go through hundreds of thousands of rows when just a few hundreds were expected to be ranked, seems it happens because it ranks all the zero values which are hidden by the filter context but still ranked by Skip RANKX, while dense allocates at most +1 rank to all the zeros. Need to revisit those measures and look into it again.

Absolutely Brilliant!

Thanks Alberto. I think isfiltered and iscrossfiltered have their place in that video. There might be more actually but these come to mind

Explained it 5 times the same way, couldn't have done better with this video. Beginners would be confused

Great Explaination Sir.

This is great but would be even better to have a summary of the whole family e.g. including HASONEFILTER, ISFILTERED, ISCROSSFILTERED with the performances differences...

Useful contents, I know why my ranking measure by date is taking forever to calculate!

Perfect!

Thanks! Sir

I have two Fact tables: Actual and Budget. I want "Actual Amt" measure to show blank each time when a user puts in pivot ANY column from Budget table. Also I want a "Budget Amt" measure to return blank each time a user uses ANY column from Actual table. What condition should I use? Thanks!

In dax guide there is a statement "When ISINSCOPE returns TRUE, then also HASONEVALUE returns TRUE." I think this needs correction. eg. in matrix grouped with brand, when are there no sales say in 2010 CY, isinscope = true but hasonevalue=false

Thanks a lot for this great explanation 🙏 I have a question: When we use some columns in SUMMARIZECOLUMNS or ADDCOLUMNS, How this columns effect on EXPRESSION? as filter context or row context?

Love your content. One question: Do you live in Pee Wee's Playhouse?

Pls comment answer it's very confusing

Slicer but not a page-level filter is used in a scenario where the data in only a few visualizations is to be filtered while others remain the same. 1. True 2. False