Forum Discussion

bvandyke's avatar
bvandyke
New Member
7 months ago
Solved

Adding Calculated Column to Matrix - based on Column values

I'm pretty sure this is possible just not sure which way to approach it.  I need to add an Untiliztion value to a matrix.  The value is based on the values in the matrix columns (see sample below).  ...
Need Help
  • cengizhanarslan's avatar
    cengizhanarslan
    7 months ago

    Here you go:

    OVH_OVH =
SUM ( Data[ovh/ovh] )

SBU_OVH =
SUM ( Data[sbu/ovh] )

SBU_PROJECT =
SUM ( Data[sbu/project] )

SBU OVD Util =
VAR Numerator =
    [SBU_OVH]
VAR Denominator =
    [OVH_OVH] + [SBU_OVH] + [SBU_PROJECT]
RETURN
DIVIDE ( Numerator, Denominator )

     

    Matrix visual:

    • Rows → Name

    • Values →

      • OVH_OVH

      • SBU_OVH

      • SBU_PROJECT

      • SBU OVD Util (the measure above)

    Format SBU OVD Util as Percentage.

     

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
7 months ago

Hi bvandyke  - If the value depends on what’s shown in the matrix, it must be a measure.
Never a calculated column.

Measure:

sbuovhdUtil =
VAR SBU_OVH =
[sbu/ovh]

VAR Total =
COALESCE([ovh/ovh], 0)
+ COALESCE([sbu/ovh], 0)
+ COALESCE([sbu/project], 0)

RETURN
DIVIDE(SBU_OVH, Total)

 

Hope this helps.