Forum Discussion
Solved
Help with Divide Function (total percentage)
Hi everyone, I’m having some trouble calculating percentages in Power BI. As you can see in the image below, I want it to show the percentage of completion for each batch separately. But right now, t...
It looks like a syntax error in your SUM(). It's missing a bracket after 'Table1'[TOTAL].
Try this instead.Total% =
DIVIDE(
'Table1'[TOTAL],
CALCULATE(
SUM('Table1'[TOTAL]),
ALLEXCEPT('Table1', 'Table1'[Batch])
)
)
Thank you for your advice. Based on your reply, I tried below computation but it throws me error 'too many arguments were passed to the SUM function. The maximum argument count for this function is 1.
Total% = DIVIDE('Table1'[TOTAL],CALCULATE(SUM(Table1[TOTAL],ALLEXCEPT(Table1,Table1[Batch]))))
It looks like a syntax error in your SUM(). It's missing a bracket after 'Table1'[TOTAL].
Try this instead.Total% =
DIVIDE(
'Table1'[TOTAL],
CALCULATE(
SUM('Table1'[TOTAL]),
ALLEXCEPT('Table1', 'Table1'[Batch])
)
)