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.

     

bvandyke's avatar
bvandyke
New Member
6 months ago

Ok, I put this in and think I understand it.  But, getting error "sbu/ovh" cannot be determined.  "sbu/ovh" is one of the values in a field (LaborCat) that is set as the Column for the matrix (LaborCat is the column for the matrix).  
How do I tell the measure to reference that?

Thanks

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    6 months ago
    Spoiler
    Hi bvandyke - you can create a base measure

    Total Hour = SUM( Labor[Hours] )

    Now create another mesure for utilización

    sbuovhdUtil =
    VAR SBU_OVH =
    CALCULATE (
    [Total Hours],
    Labor[LaborCat] = "sbu/ovh"
    )

    VAR Total_All =
    CALCULATE (
    [Total Hours],
    Labor[LaborCat] IN { "ovh/ovh", "sbu/ovh", "sbu/project" }
    )

    RETURN
    DIVIDE ( SBU_OVH, Total_All )

     

     

    This should be works.

    Check and confirm.