Forum Discussion
Total Not Calculating Right in Matrix
Hello Community, I'm pretty new to Power BI and still struggling with calculating totals correctly in Matrix. In the sample dataset, I want the "Total" column in the matrix to always represe...
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.