Query context is different from filter context. What you explained it as query context was filter context ......here is the correction ...in fact , query context is subset of data ( it's not about SQL source data ) created for each cell in a pivot table ....query context is more related with pivot table not SQL query..
While summarize column gives the best performance, you can use any fact attribute doesnt matter us sales or us revenue but the results will vary depending on the column and its size..
Osm explanation ❤️
Finally got the filter context logic.. thanks
Thanks, stay tuned...
Query context is different from filter context. What you explained it as query context was filter context ......here is the correction ...in fact , query context is subset of data ( it's not about SQL source data ) created for each cell in a pivot table ....query context is more related with pivot table not SQL query..
This is referenced in Microsoft docs as well.. but I hope you got some understanding from this..
Can you please clarify, which calculation is right. US Sales OR US REVENUE? They have given substantially different results.
While summarize column gives the best performance, you can use any fact attribute doesnt matter us sales or us revenue but the results will vary depending on the column and its size..