The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.