Forum Discussion
Matrix Table Calculated Sub-Total
Goo day all. I have derived Matrix table as below and managed to have total and grand-total working correctly. How to derive total 3 which is the sum of total 2 & 1 and not from calculated balanc...
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/
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?