Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |