Forum Discussion

RENJITH_R_S's avatar
RENJITH_R_S
Resolver II
1 year ago
Solved

Reverse Total Calculation on Matrix Visual

Hello Friends, I have a matrix visual with Row Header as Title Contains 2 values benefits, cost and column header as year 2023,2024 and 2025 and value is a measure with calculation value = sum(column...
Need Help
  • RENJITH_R_S's avatar
    RENJITH_R_S
    1 year ago

    I got answer

    _Matrix_Variance$ =
    if (ISINSCOPE('Table'[Title]),
    [_Measure],
    CALCULATE([_Measure],'Table'[Title]="Benefit")-CALCULATE([_Measure],'Table'[Title]="Cost"))
RENJITH_R_S's avatar
RENJITH_R_S
Resolver II
1 year ago

I got answer

_Matrix_Variance$ =
if (ISINSCOPE('Table'[Title]),
[_Measure],
CALCULATE([_Measure],'Table'[Title]="Benefit")-CALCULATE([_Measure],'Table'[Title]="Cost"))