TOPN

First, what do we want to rank by ... # of Incidents - let's make a measure for that:

NumIncidents:= COUNTROWS(IncidentsTable)

This assumes of course that the incidents table is one row per incident, if that wasn't the case then you'd want to do a distinctcount on the incidentid

NumIncidents:=DISTINCOUNT( IncidentsTable[IncidentsID] )

Second, we want to rank the systems by the number of incidents - let's make a measure for that

RankSystemsByIncident:=RANKX( ALL( IncidentsTable[System] ), [NumIncidents] )

The piece most people miss here is the ALL() - we don't want to rank the system against itself - we want to rank the system against all the other systems.

Third, we want to return a certain number of systems based on a choice - let's pretend for a second that we just want to return all the systems with their rankings - we would put the systems on the rows and drop the ranking in the values. PowerBI has a TOPN function that you could play around with.

Shoot, I have to run to a meeting but this should get you started :)

Thank you so much. It worked as expected.

Hi thliberato,

I am very glad to hear you have resolved your problem. In order to help more people, please mark the corresponding solution as answer. Thanks a lot.

Best Regards,
Angelia

Hi v-huizhn-msft, I am new and I didnt find the function (mark as answer).

Can you Help me again ?

Hi thliberato,

Please review the folloowing screenshot, just click the "Accept as Solution" highlighted in red line.



Best Regards,
Angelia