Forum Discussion
Ranking Subjects.
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
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!
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