Forum Discussion

veshva40's avatar
veshva40
Regular Visitor
10 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
    10 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
Icon for Super User rankSuper User
10 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