Forum Discussion

Helper II

6 years ago

Solved

RANKX with condition

Hi, I am trying to create a RANKX measure on customers meeting a certain revenue conditions. Rank top 100 = VAR Customer_list = FILTER( ALLSELECTED(Revenue[Customer]), [Revenue total] ...

amitchandak
6 years ago
Maikeru , Prefer filter in measure and then use it RankX. Means have all filter in the measure and then use that measure in Rank

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

Community Champion

6 years ago

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490