Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
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!
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!
This worked. Thank you for your suggestion.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
94 | |
72 | |
68 | |
41 | |
39 |