Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello All,
I have seen so many posts and tried their solutions but nothing is working out. Please help me with this ranking:
I have my Data for sles with names and year:
Names Year Sales
A 2019 222
A 2019 456
A 2018 678
B 2019 555
B 2018 33
C 2018 23
I have two slicers for Name and Year: I want to show th rank of selected name with selected year. If year is not selected then combine ranking of 2018+2019 sales. My ranking is coming fine in table but its coming wrong in card.
Please Help!
C
Solved! Go to Solution.
Hi @Vish24
try this...
rank = RANKX(ALL('Table'[Name]),CALCULATE(SUM('Table'[Sales])),,DESC,Dense)
... and put an advanced filter on the (card) visual "Table [Year] is not blank"
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.