Forum Discussion

TCavins's avatar
TCavins
Helper V
6 years ago

RANKX Help

I have a table with the following columns.   Person Site Manager IncidentID   I want my visualization to be: Person, Site, Manager, DISTINCTCOUNT(IncidentID), Rank(1 - whatever, based on the ...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi TCavins ,

 

Try  to create a calculated column as below:

 

 

 

Column =
VAR summry =
    SUMMARIZE (
        ALLSELECTED ( MyTable ),
        [Person],
        "DistCount", DISTINCTCOUNT ( MyTable[INCIDENTID] )
    )
RETURN
    RANKX ( summry, [DistCount],, DESC, DENSE )

 

 

 

Best Regards,
Kelly

TCavins's avatar
TCavins
Helper V
6 years ago

This isn't working for me.