Forum Discussion
Incorrect Total / Missing Total based on Ranking
Hi Team, I'm not able to get the measure total correct after ranking based on another measure. Let me make it more clear: I have below given matrix table with details. Ranking is done based ...
provide a PBIX file to solve this issue by looking as far i see you are not adding current and previous rows value to get total for example
your total iteration=Total number of accounts
than do first iteration
current total=current year value row
also set
previous total =current total
than next iteration
current total =previous total +current year value
Total =current total