Forum Discussion

aulona12's avatar
aulona12
Frequent Visitor
3 years ago
Solved

How to create calculated rows in the matrix?

Hello everyone, 

 

I am trying to add calculated row % in the matrix but i am having a hard time. Some help please? 

 

This is the original table : 

 

 

This is the desired result (the additions are all in red)

 

 

 

 

Here is the formula view : 

 

 

 

Thanks in advance for any help that you can provide

 

 

 

Need Help
Show and Tell
  • YukiK's avatar
    YukiK
    3 years ago

    Create a measure like the following and use it in your matrix instead:

    Your Measure = 
DIVIDE(
    SUM(YourTable[YourColumn]),
    CALCULATE(
        SUM(YourTable[YourColumn]),
        ALLSELECTED(Yourtable[YourMonthColumn])
    )
)

     

    Give it a thumbs up and accept as solution if you find this helpful!

2 Replies

  • YukiK's avatar
    YukiK
    Icon for Impactful Individual rankImpactful Individual
    3 years ago

    Create a measure like the following and use it in your matrix instead:

    Your Measure = 
DIVIDE(
    SUM(YourTable[YourColumn]),
    CALCULATE(
        SUM(YourTable[YourColumn]),
        ALLSELECTED(Yourtable[YourMonthColumn])
    )
)

     

    Give it a thumbs up and accept as solution if you find this helpful!

    • aulona12's avatar
      aulona12
      Frequent Visitor
      3 years ago

      This worked. Thank you for your suggestion.