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.

     

v-achippa's avatar
v-achippa
Community Support
6 months ago

Hi bvandyke,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you rajendraongole1 and cengizhanarslan for the prompt response. 

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Community Support
6 months ago

Hi @bvandyke,

 

We wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa