Ranking Subjects.

[janisCNH]

Hello Guys!

I have a problem with a ranking for a report. The ranking should contain the top 5 issus of a technical support. You can see this data under Subject in the attached picture. Is it possible to rank the count of the subjects?

Thanks for any help!

Janis  

 

[janisCNH]

Hi!

At first, thank you two for the quick answer. The kind community from Power BI really helps to better get into my reporting project!

On the attached pictures, you can see my workingsteps. The program says that I did something wrong. Can you explain it to me? I am really not that familiar with Power BI yet.

thx!

[Anonymous]

Hello @janisCNH

you use the UNION keyword, which is made to unifiy two tables with corresponding columns, but, you passed A field with multiples values and a aggregate fields for the second argument.

I don't know why you want ton unify this two objects, but, if you want to display them in a table, you don't have to do this, just use the "Subject" field, and the "Subject rank" measure.

If this not what you want to do, tell it to me.

Sebastien

[asocorro]

Create a measure [Subject Count] and then rank based on it, with a measure [Subject Rank] =  RANKX(ALL(TableName[Subject]), [Subject Count]).  Create a table with the columns Subject and [Subject Rank].  

As to displaying the top 5, one way is to filter the visual with [Subject Rank] <= 5.

[Anonymous · Accepted solution]

Hello @janisCNH

I think the solution explain by @asocorro is good, but you may need something more.

If your ranking is used for selected objects (just like slicer for example) you have to replace the ALL keywork by the ALLSELECTED. 

It should recalculate the ranking based only on the selected members.

Sebastien