cancel
Showing results for
Search instead for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Anonymous
Not applicable

## Ranking in matrix doesn't work with filter

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])
)

RETURN
Result

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.

Any idea?

Thank you.

Regards,

Ilias

1 ACCEPTED SOLUTION
Community Support

Hi @Anonymous ,

Please check this formula.

``````Ranking =
CALCULATE (
RANKX (
FILTER (
ALLSELECTED ( ZV048 ),
ZV048[Name 1] = SELECTEDVALUE ( ZV048[Name 1] )
),
ZV048[Total weight formula],
,
DESC,
DENSE
),
ALLSELECTED ( 'Calendar'[Date].[Année] )
)``````

If it doesn't work, please share the pbix to us so that we could test formula.

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
3 REPLIES 3
Community Support

Hi @Anonymous ,

Please check this formula.

``````Ranking =
CALCULATE (
RANKX (
FILTER (
ALLSELECTED ( ZV048 ),
ZV048[Name 1] = SELECTEDVALUE ( ZV048[Name 1] )
),
ZV048[Total weight formula],
,
DESC,
DENSE
),
ALLSELECTED ( 'Calendar'[Date].[Année] )
)``````

If it doesn't work, please share the pbix to us so that we could test formula.

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Super User

@Anonymous , Try

RANKX(Summarize(allselected(ZV048), ZV048[Name 1],'Calendar'[Date],ZV048[Shipping type] ), ZV048[Total weight formula],, DESC, DENSE )

Anonymous
Not applicable

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 ?

Total weight formula = SUM(ZV048[Total Weight])

Ilias

## Helpful resources

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors