Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
Hello everyone !
I'm trying to rank my total weight per client (name 1 in the matrix).
To do this, I used this formula which gives me a correct ranking :
Ranking =VAR Customers =ALLSELECTED(ZV048[Name 1])VAR Result =CALCULATE(RANKX(Customers, ZV048[Total weight formula],, DESC, DENSE ),REMOVEFILTERS( ZV048 ),VALUES('Calendar'[Date].[Année]),VALUES(ZV048[Name 1]),ALLSELECTED(ZV048[Shipping type]))
However, when I use my Shipping type filter, the ranking does not act intelligently :
Indeed, by choosing a shipping type filter I would like to have a ranking starting from 1.
Go to Solution.
Hi @Anonymous ,
Please check this formula.
ALLSELECTED ( ZV048 ),
ZV048[Name 1] = SELECTEDVALUE ( ZV048[Name 1] )
ZV048[Total weight formula],
ALLSELECTED ( 'Calendar'[Date].[Année] )
If it doesn't work, please share the pbix to us so that we could test formula.
View solution in original post
@Anonymous , Try
RANKX(Summarize(allselected(ZV048), ZV048[Name 1],'Calendar'[Date],ZV048[Shipping type] ), ZV048[Total weight formula],, DESC, DENSE )
Thank you @amitchandak ,
Here is the result using this formula :
Various clients have the same ranking.
And using a shipping type filter:
Maybe something wrong with my Total weight formula ?
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.