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

Praful_Potphode's avatar
Praful_Potphode
Super User
9 months ago

Hi veshva40 ,

try creating below measure:

percentage = DIVIDE(
     SUM(Demo[Total Person]),
     CALCULATE(SUM('Demo'[Total Person]),ALLEXCEPT('Demo','Demo'[Batch]))
)

 

Please Give Kudos or mark it as solution once confirmed.

 

Thanks and Regards,

Praful