Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have mulitple measures against a column in my table visual in Power BI. One such column is group column which groups the product as Group A, Groupb and so on.. Another measure is Total sales. So, if i want to rank my Product name column based on Group measure and Total Sales, how shall I do that? I'm only able to retreive ranking on the basis of Total sales
Solved! Go to Solution.
Hi @Anonymous,
Create a column as below:
Group rank = RANKX(FILTER(ALL('Table'),'Table'[Product Groups]=EARLIER('Table'[Product Groups])),'Table'[ Shipped-Issues],,DESC,Dense)
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Can anyone help on above please?
Hi @Anonymous,
Create a column as below:
Group rank = RANKX(FILTER(ALL('Table'),'Table'[Product Groups]=EARLIER('Table'[Product Groups])),'Table'[ Shipped-Issues],,DESC,Dense)
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Thanks a ton 🙂 This is what i wished to achieve. Have a nice day!
Rank on the basis of total sales. Then just pull group as the legend or x-axis or something on the visual?
Need it on table visual, ranking isn't moving with respect to group measure (Product Groups).
Consider the attached sample : Trying to rank on basis of Shipped - Issues Raised
Can anyone please help?
Hi @Anonymous ,
Could you pls provide an expected output based on your sample data ?
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Please check below table, I want output to come as below. Also note for Groups I craeted measure as
Product Groups =
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.