Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculating Percentage on Rows

Greetings! I have the following table in Power BI (see below). Colletion % is currently a Measure that looks like this:

Collection %=DIVIDE('Data'[Init Bal], 'Data'[Total Pmts], 0). It works fine, until I summarize the data by the Zip code, and then it no longer calculates the Collection % Correctly.

I need some help with the DAX to make sure that if I summarze by Zip or some other attribute, it still calculates correctly.

 

Thank you in advance!

 

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , You show use measure

    Collection %=DIVIDE(sum('Data'[Init Bal]), sum('Data'[Total Pmts]), 0).

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , You show use measure

    Collection %=DIVIDE(sum('Data'[Init Bal]), sum('Data'[Total Pmts]), 0).