Forum Discussion
Solved
groupby / summarize / filter
Hi, I have got a query in power bi and the table what I'm trying to group or summarize (but in the same table) has various columns. "Store", "Style Key", "Style Color", "Sales Qty", "Stock Qt...
Hi XaverScheu70
In that case, we can add Store Column in the ALLEXCEPT arguments
F1 = CALCULATE ( SUM ( Table1[Stock Qty] ), ALLEXCEPT ( Table1, Table1[Store] ,Table1[Style Key] ) ) F2 = CALCULATE ( SUM ( Table1[Sales Qty] ), ALLEXCEPT ( Table1,Table1[Store], Table1[Style Key] ) )
Here is the documentation of ALLEXCPET function
https://msdn.microsoft.com/en-us/query-bi/dax/allexcept-function-dax
Zubair_Muhammad
Community Champion
Community ChampionHi XaverScheu70
In that case, we can add Store Column in the ALLEXCEPT arguments
F1 = CALCULATE ( SUM ( Table1[Stock Qty] ), ALLEXCEPT ( Table1, Table1[Store] ,Table1[Style Key] ) ) F2 = CALCULATE ( SUM ( Table1[Sales Qty] ), ALLEXCEPT ( Table1,Table1[Store], Table1[Style Key] ) )
Here is the documentation of ALLEXCPET function
https://msdn.microsoft.com/en-us/query-bi/dax/allexcept-function-dax
