Forum Discussion
Total Not Calculating Right in Matrix
Hi encamped1
You can use the following measure
Measure = var a=SUMMARIZE(VALUES(Orders[State]),[State],"distinct",DISTINCTCOUNT(Orders[Customer ID]))
return SUMX(FILTER(a,[State] in VALUES(Orders[State])),[distinct])
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
You're the best!
One last ask - can we create a single measure that would work more dynamically? i.e. if the State realted contents in the matrix, show the sumx of the States, if a Matrix has the category field as a row, show the sumx of the sub-category based total at the bottom of the table,, etc.
Hi encamped1
You can use isincope() function to judge, you can refer to the following link.
ISINSCOPE function (DAX) - DAX | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.