RANKX sum of articles sold by seller ID (group)

[smnfx]

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!

[v-mengzhu-msft · Accepted solution]

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

[smnfx]

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!

[Jihwan_Kim]

Hi,

Thank you for your feedback.

Please try the below. 

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

[Jihwan_Kim]

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