Forum Discussion
Solved
Total Calculation for Matrix Visual
Hello Friends, can you help me on this calculation, I have a matrix visual with 2 columns say Item having values A,B,C on the Row header and year having values 2023,2024 and 2025 as column header and...
Hi RENJITH_R_S
You can use isinscope function to manipulate the measure accorsing to hierarchie level .Sum_ =if (ISINSCOPE('Table'[Category]),sum('Table'[Value]),CALCULATE(sum('Table'[Value]),'Table'[Category]<>"A"))Result :
The pbix with the example is attached
More information aboit isinscope here :
https://www.youtube.com/watch?v=DtOfcsS_pQw
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi RENJITH_R_S
You can use isinscope function to manipulate the measure accorsing to hierarchie level .
Sum_ =
if (ISINSCOPE('Table'[Category]),
sum('Table'[Value]),
CALCULATE(sum('Table'[Value]),'Table'[Category]<>"A"))
Result :
The pbix with the example is attached
More information aboit isinscope here :
https://www.youtube.com/watch?v=DtOfcsS_pQw
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Ritaf1983 Thank you
Glad to help 🙂
