Forum Discussion
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 a...
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!
YukiK
Impactful Individual
Impactful IndividualCreate 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!
This worked. Thank you for your suggestion.