Forum Discussion

bajimmy1983's avatar
bajimmy1983
Advocate V
9 years ago
Solved

Dynamic RANKS using CARDS elements

Hello Community, how are you?    Could you please help me? PBIX file I am using.   Each Client participates in one or more than one GLOBAL GROUP. There are 02: HAVAS CREATIVE and HAVAS MEDIA. Und...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi bajimmy1983,

     

    >>So, I have tried as you suggested, but the problem persists when I have all Slicers selected (last print below). Maybe I am doing something wrong yet.

    After I modify the formula from your steps, it still works on my side:

    Z_Rank Dynamic = 
    	IF(ISBLANK([Invest Pilot BRL]),BLANK(),
    		IF(ISFILTERED(Pilot[GLOBAL GROUP])&&ISFILTERED(Pilot[GROUP]),//check if isfiltered global group and group at same time
    		RANKX(ALL(Pilot[CLIENT]),[Invest Pilot BRL],,0,Dense),//client
    		RANKX(ALLSELECTED(Pilot[CLIENT]),[Invest Pilot BRL],,0,Dense))//global
    		)

     

     

    Regards,

    Xiaoxin Sheng