Forum Discussion
Matrix Table Calculated Sub-Total
Chewbc , Use is in scope and category values
if(not(isinscope(Table[Sub Category]) ) && max(Table[Sub Category]) = "12. Total Cost", [Sub Total Meausre], [Measure])
TO create a measure you can use like
sumx(filter(allselected(Table[Category]), Table[Category] in {"Finance Cost", "Selling and Distribution"} ), [Measure])
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Thanks mate for the reply. Yes I managed to used sumx to correct my intial problem on Grand-Total from matrix table. WIll try your suggestion and post the results here...
Thank you.
Hi amitchandak I managed to get the results based upon DAX syntax suggested (see below).
The AMOUNT and CPDOC-QS for category "12. TOTAL COST (WO BY PRODUCTS" are sum from category 01. to 11. How to force the value Sub-Total and Sub-Total-CPQS to show under AMOUNT and CPDOC-QS column?
