Forum Discussion
How do i add Ranking to Multiple Rows with the same brand but different models
Hi, I am new to Power BI and need your assistance Basically i have a table in power BI as below which i would like to rank by item based on number of units sold, The only thing is there are mu...
Hi, thank you for responding.
This is my initial formula
Rank Units Sold =
RankX (All('Table'),
CALCULATE(SUM('Table'[Sales Units])),,DESC,Dense)
Now i tried adding allselected but its still giving me Ranking For each brand and not outlining the Individual ranking for each item.
I trust this makes sense, as in addition i would like this to dynamically change when i select a different Business Unit(Segment)
I trust this makes sense, as in addition i would like this to dynamically change when i select a different Business Unit(Segment)
Thanks
Hi Anonymous
As tested, with this formula,
Measure 2 = RANKX(ALLSELECTED(Sheet2),CALCULATE(SUM(Sheet2[Sales units])),,DESC)
It is ranked for each item, when i select a brand, it will rank for each item of the brand.
How about writing another meausre
Measure = SUM(Sheet2[Sales units])
Then use this measure in the rank formula
Measure 2 = RANKX(ALLSELECTED(Sheet2),[Measure],,DESC)
If it doesn't help, please show an screenshot of yours,
or download my pbix from my previous reply, based on my pbix, tell me what's wrong i make to understand your requirement, give the correct rank result you expected.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.