Ranking + Percentage issue
I have very simple table : [dimension], [measure], Percentage ([measure]) + few filters and input controls based on other dimensions.
Everything works nice and as expected.
The issue is when I apply Rank i.e. top 10 on this table. Calculated column "Percentage ([measure])" didnt calculate results as I expect, Percentage function uses only top 10 values. I need to calculate percentage from all not only top 10 values.
Normally for this issue there is workaround with function NoFilter(), but this can be used only if in report arent other filters or input controls.
What I need is something like NoRank() function, so not all filters and input controls arent ignored.
Please any ideas how I can achieve what I need?
Thanks for any help!