Calculating Percentage on Rows

[Anonymous]

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!

[amitchandak · Accepted solution]

@Anonymous , You show use measure

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