This is a great video and a great conversation. For those of us who have fallen in love with DAX, the succinct walkthrough of the SUMMARIZECOLUMNS semantics and solution sequence crystallizes why (once you learn DAX) the “mental model simplifies” down to the cross-join space and a set of filters… at which point you run your arbitrarily complex measures row-by-row. Wow! You can understand and explain any PBI visual behavior with that one slide! Thanks for producing this video!!
In Power BI, is this statement correct? In SUMMARIZECOLUMNS, the filter context will ignore any expansion columns in the filtering section of SUMMARIZECOLUMNS. Please explain. One more note, the dax query that is generated by visuals combines all external filters into one big filter. (you have 2 filters in your example) Thank you for this great video and for answering my questions! :)
Great question! It's in depth enough that I'd recommend posting this to the Power BI community forums so other people will have more exposure for your answer as well :) community.fabric.microsoft.com/
I did my own validation and I found SUMMARIZECOLUMNS can use the extension table for filtering using SUMMARIZE in the filtering section without any issues. EVALUATE SUMMARIZECOLUMNS( Actuals[Class], Actuals[Location], CALCULATETABLE(SUMMARIZE(Actuals, 'PS Type'[Type]), 'PS Type'[Type] = "Direct Hire")// PS TYPE is an expansion table of Actuals table ) // This query works exactly as expected where I used the extension columns as a filter
Really good session! Thanks for getting Jeffrey on the channel.
This was simply incredible! I will listen to JeffreyWang read the phone book-he’s that good!!!
He's fantastic for sure!
This is a great video and a great conversation. For those of us who have fallen in love with DAX, the succinct walkthrough of the SUMMARIZECOLUMNS semantics and solution sequence crystallizes why (once you learn DAX) the “mental model simplifies” down to the cross-join space and a set of filters… at which point you run your arbitrarily complex measures row-by-row. Wow! You can understand and explain any PBI visual behavior with that one slide! Thanks for producing this video!!
You're welcome!
must see tv....Thanks Reid! Thanks Jeffrey!
High Quality Content™
In Power BI, is this statement correct?
In SUMMARIZECOLUMNS, the filter context will ignore any expansion columns in the filtering section of SUMMARIZECOLUMNS. Please explain.
One more note, the dax query that is generated by visuals combines all external filters into one big filter. (you have 2 filters in your example)
Thank you for this great video and for answering my questions! :)
Great question! It's in depth enough that I'd recommend posting this to the Power BI community forums so other people will have more exposure for your answer as well :)
community.fabric.microsoft.com/
@@HavensConsulting Thank you 😊 I will
I did my own validation and I found SUMMARIZECOLUMNS can use the extension table for filtering using SUMMARIZE in the filtering section without any issues.
EVALUATE
SUMMARIZECOLUMNS(
Actuals[Class],
Actuals[Location],
CALCULATETABLE(SUMMARIZE(Actuals, 'PS Type'[Type]), 'PS Type'[Type] = "Direct Hire")// PS TYPE is an expansion table of Actuals table
) // This query works exactly as expected where I used the extension columns as a filter
@@AHMEDALDAFAAE1 thank you for this information. Really appreciated