Forum Discussion
HugoJesus
Helper IV
Helper IVRANK BASED EXPRESSION TABLE
Hi everyone, I need help with this, I've searched in all forums but, noone have a solution to my case. For better understanding, I've attached the example of my PBIX, in a very very simple w...
To solve my problem I've used this. ..
Breaking Ties in Rankings with RANKX Using Multipl... - Microsoft Power BI Community
v-jianboli-msft
Community Support
Community SupportHi HugoJesus ,
If you apply the filer on the page level, the data will be filtered on this report page. In this condition, after you applied the filter Hotel = 2 , the sum value will be like this:
If you do not want the result be changed by the filter, consider using calculated column like RANK_TAB, instead of using measure.
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.