Forum Discussion

TommyMossberg's avatar
TommyMossberg
Helper I
5 years ago
Solved

Sum Measure in Col - Matrix Visual

I have a measure that summarizes if value is greater than 0 (Calc - Tillgänglig) and another that summarize if the value is bellow 0 (Calc - Överallokering)   Calc - Tillgängligt = VAR Planned =...
Measure Column Total
  • TommyMossberg's avatar
    TommyMossberg
    4 years ago

    I did not manage to get the second measure work the way I wanted so I created a new table in Power Query were each column represents a measure. Then the sum are correct on my subtotals.

dedelman_clng's avatar
dedelman_clng
Community Champion
5 years ago

Hi TommyMossberg -

 

Instead of putting the two measures directly into the matrix, add a second measure for each that does the subtotals correctly

 

Tillganglig_Display =
IF (
    HASONEVALUE ( STotal_Tab[Employee] ),
    [Tillganglig],
    SUMX ( STotal_Tab, [Tillganglig] )
)

 

Hope this helps

David

TommyMossberg's avatar
TommyMossberg
Helper I
4 years ago

I did not manage to get the second measure work the way I wanted so I created a new table in Power Query were each column represents a measure. Then the sum are correct on my subtotals.