Forum Discussion
Solved
Dynamic Ranking with slicers without summation of values
I have a Table in excel by the name "Compiled" which I have loaded in Power BI. It has the following columns: Month Segment SUPPLIER CODE SUPPLIER NAME DOMAIN Overall Score (Rounded Off) ...
I used another two DAX measures:
MAX(f_Data[Overall Score (Rounded Off)]) Rank Score base on Max = RANKX( ALLSELECTED(f_Data[DOMAIN],f_Data[SUPPLIER NAME], f_Data[Segment], f_Data[SUPPLIER CODE]), [MAX Score], ,DESC )The final output was this:
_AAndrade
Resident Rockstar
Resident RockstarI used another two DAX measures:
MAX(f_Data[Overall Score (Rounded Off)])
Rank Score base on Max =
RANKX(
ALLSELECTED(f_Data[DOMAIN],f_Data[SUPPLIER NAME], f_Data[Segment], f_Data[SUPPLIER CODE]),
[MAX Score],
,DESC
)The final output was this:
It worked! Thanks alot