Forum Discussion

bvandyke's avatar
bvandyke
New Member
6 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
    6 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.

     

cengizhanarslan's avatar
cengizhanarslan
Super User
6 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.