Forum Discussion
Solved
Showing Rank
Hi I have a table which has 2 fileds (Item and Amount). When click on the field, I see option "Show value as percentage". In Excel pivot table, there is an option to show as Rank, Running Total etc....
Hi lastnn30 ,
For seeing the option "Show value as percentage" you can refer @ Ibendlin suggestion but for Rank and Running total you required dax. Refer below URL's for Rank and Running total.
https://www.sqlbi.com/articles/use-of-rankx-in-power-bi-measures/
https://www.sqlbi.com/articles/computing-running-totals-in-dax/
Thanks,
Samarth
