Struggling with an % of row total.

[tbobolz]

Hi, I have been struggling with creating a percentage of row totals that break on year. The total column states that it adds up to 100%, but it actually does not. I have a measure that places payers into 4 category called, "Payer Big 4 Roll-up" I thought I used it correctly in my formula pictured below, but I must not have. I'm learning and think I need to add a year factor to the formula.

Thanks for any advice you can offer.

Terry

[tbobolz · Accepted solution]

After playing with this for some time, I realized my formula was fine; however, when interacting with filters on the page, they were in conflict with the formula's filters. I removed the filters impacting it, as I could not account for any possible action the end usr may take. 

[SamWiseOwl]

Hi @tbobolz ,

If you change the number of decimal places does it add up? I imagine that this is DAX rounding up when showing the two decimal places.
You could force the total to work out each of these seperetly and sum but that could be misleading.

[LeandroDeodato]

try use round(sum(1)/sum(2),2)

[tbobolz]

Thanks for the reply. Would you be kind enoung to show me an example on apllying this in the formula?