Forum Discussion

veshva40's avatar
veshva40
Regular Visitor
9 months ago
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...
Need Help
  • MasonMA's avatar
    MasonMA
    9 months ago

    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])
    )
    )

MasonMA's avatar
MasonMA
Super User
9 months ago

Hi, 

 

I assume your current Measure probably looks like 
Total % = DIVIDE([Total Person], CALCULATE(SUM('Table'[Total Person]), ALL('Table'))) ?

If so, it removes all filters, including the Batch filter so the denominator is the grand total of all batches.

Try updating your denominator to 
CALCULATE(
SUM('Table'[Total Person]),
ALLEXCEPT('Table', 'Table'[Batch])
)

so that it removes all filters except the batch.