Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I have the below matrix table (cannot show first row, but it is an Account Name with Indiviaul Purchases underneath):
The income percentage formula I used is DIVIDE( Income, Cost ).
As you can see, they aren't calculating correctly. For example, the third row should show 23.86% but it is returning 28.76%. I have it set to show the Average, as this is the closest result. Does anybody have any idea what's causing this?
Thank you.
Solved! Go to Solution.
Hi @GeorgeG
Just like amitchandak has replied, you need to build a measure. And you need if function to make your result see 0.
I build a table like yours.
Measure:
Income Percentage =
VAR _A = DIVIDE(SUM('Table'[Income]),SUM('Table'[Cost]))
Return
IF(_A=0,0,_A)
Result:
You can download the pbix file from this link: Percentages aren't calculating correctly
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @GeorgeG
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Rico Zhou
Hi,
I found the issue that was causing this. I have a rather large dataset in which the Account Names are connected to multiple figures underneath. It looks like it was calculating the percentage of other figures against the Account Name, to fix this I selected the following options within PowerBI:
@GeorgeG , Can you share the formula,
hope it
divide(Sum(Table[Income]),sum(Table[Cost]))
not
average(divide((Table[Income]),(Table[Cost])))
Hi @amitchandak , the formula is as follows:
DIVIDE(
(Table[Income]),
(Table[Cost])
)
If I add SUM to the formula, the below is shown:
This is with the Average option selected, either option returns incorrect (If I use the SUM option, it shows over 300% for all rows):
Thank you.
Hi @GeorgeG
Just like amitchandak has replied, you need to build a measure. And you need if function to make your result see 0.
I build a table like yours.
Measure:
Income Percentage =
VAR _A = DIVIDE(SUM('Table'[Income]),SUM('Table'[Cost]))
Return
IF(_A=0,0,_A)
Result:
You can download the pbix file from this link: Percentages aren't calculating correctly
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@GeorgeG , Create a measure like
DIVIDE(
sum(Table[Income]),
sum(Table[Cost])
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |