Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Measure for MAX Rank

Need help in creating a measure to count the number of promotors based on latest date for NPS .   I have created  Rank using   RANK = RANKX( FILTER(Table1, Table1[Topic] = EARLIER(Table1[Topic]...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

Replace order by DESC instead of ASC and then hardcode Rank=1 in your measure.


RANK = RANKX(
FILTER(Table1,
Table1[Topic] = EARLIER(Table1[Topic]) &&
Table1[EmpID]=EARLIER(Table1[EmpID])
),
Table1[Submit_Date].[Date],
,DESC,Dense)

Measure = CALCULATE(COUNT(Table1[EmpID]),
FILTER(Table1,Table1[type] = "Promoter"),
FILTER(Table1,Table1[Response] = "Yes"),
FILTER(Table1,Table1[Rank] = 1 )

Best Regards,
Mail2inba4

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

The problem with hardcoding is that if someone changes the date slicer it doesn't work dynamically and is stuck to the latest latest .

So if November is Rank1 and someone changes the date slicer to Oct  - The rank doesn't change