Forum Discussion
percentage total
I hate to say this without a firm solution, but that is probably your issue with the totals. I noticed this in my Ohio State Football Wins %. The solution was to move the calculation to a Measure and then the totals were correct. I'd have to know a little more about your data to give you a 100% solution, the way that I did my win percentage calculation in my Ohio State Football report was:
Winning % = SUM([Wins]) / (SUM([Wins]) + SUM([Losses]) + SUM([Ties]))
Then, the context of the visual would calculate things out correctly. For example, I could put this in a matrix along with Coach and Year and all of the individual rows would be correct as well as all of the totals.
hi i have it as a column with the follwing formula
Margin % = ('posted sales trans_ (2)'[Margin $ (LCY)]/' posted sales trans_ (2)'[Sales (LCY)])*100
Community ChampionI hate to say this without a firm solution, but that is probably your issue with the totals. I noticed this in my Ohio State Football Wins %. The solution was to move the calculation to a Measure and then the totals were correct. I'd have to know a little more about your data to give you a 100% solution, the way that I did my win percentage calculation in my Ohio State Football report was:
Winning % = SUM([Wins]) / (SUM([Wins]) + SUM([Losses]) + SUM([Ties]))
Then, the context of the visual would calculate things out correctly. For example, I could put this in a matrix along with Coach and Year and all of the individual rows would be correct as well as all of the totals.