topic RANKX sum of articles sold by seller ID (group) in DAX Commands and Tips

RANKX sum of articles sold by seller ID (group)

smnfx — Mon, 04 Jul 2022 15:30:37 GMT

Hi all,

I feel stupid asking this, because it must be pretty easy to do.
I've checked multiple other similar cases I could find here and on google. Normally these help solve my issues, but somehow I am not able to get behind it myself...

Here goes:

I need to Rank the products sold by MA ID:

Table Name: 'SumArtikelMitarbeiter' (created from other tables with SUMMARIZE)

So it ranks the sold articles (value in column: [SumVerkauft]) for every [MA ID] like it is in the screenshot.

For every MA ID the ranking starts from 1 to X, so I know which article was most sold and least sold by seller.

I've tried multiple suggestions, like:

Column = RANKX(ALL(SumArtikelMitarbeiter[MA ID]), [SumVerkauft])

I also tried with a SUM(SumArtikelMitarbeiter[SumVerkauft]) measure instead of the [SumVerkauft] row

or with ALLEXCEPT

but it's only showing 1s in every row.

Do you guys have a tip for me to have DAX rank the [SumVerkauft] grouped by [MA ID]?

I can also share the report, it's just to play around in and replicate "problems".

THANK YOU!

Re: RANKX sum of articles sold by seller ID (group)

Jihwan_Kim — Mon, 04 Jul 2022 17:10:57 GMT

Hi,

I am not sure if I understood your question correctly but could you please try the below?

It is for creating a new column.

Column = RANKX ( FILTER ( SumArtikelMitarbeiter, SumArtikelMitarbeiter[MA ID] = EARLIER ( SumArtikelMitarbeiter[MA ID] ) ), CALCULATE ( SUM ( SumArtikelMitarbeiter[SumVerkauft] ) ) )

Re: RANKX sum of articles sold by seller ID (group)

smnfx — Tue, 05 Jul 2022 10:07:00 GMT

Hi Jihwan_Kim !

Thank you for taking the time to have a look at my problem :).

Unfortunately, if I paste your code into a new column, it says it detected a circular dependancy:

I can also try to describe my situation differently if it is unclear.

Thanks again!

Re: RANKX sum of articles sold by seller ID (group)

Jihwan_Kim — Tue, 05 Jul 2022 11:03:33 GMT

Hi,

Thank you for your feedback.

Please try the below.

Column = RANKX ( FILTER ( SumArtikelMitarbeiter, SumArtikelMitarbeiter[MA ID] = EARLIER ( SumArtikelMitarbeiter[MA ID] ) ), SumArtikelMitarbeiter[SumVerkauft] )

Re: RANKX sum of articles sold by seller ID (group)

Anonymous — Thu, 07 Jul 2022 06:57:30 GMT

Hi smnfx ,

You can try this measure:

sort = rankx( summarize(filter(allselected('SumArtikelMitarbeiter'),[ma id]=selectedvalue('SumArtikelMitarbeiter'[ma id])),[ma id],[sumverkauft]),calculate(sum('SumArtikelMitarbeiter'[sumverkauft])))

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly