2 rankings in same tbale

[gramespa]

Hi all,

i have a table containing suppliers and net value per supplier for Materials and for services. Too create two ABC analysis, one showing A suppliers for materials, one showing A suppliers for services, i would like to rank my suppliers a) per value materials b) per value services.

While this code worked perfectly fine for a it is giving me circular error when being used for b with slight adjustments 

 Ranking Value NU =

RANKX(Kreditoren; Kreditoren[Nettobestellwert NU je Kreditor];Kreditoren[Nettobestellwert NU je Kreditor];DESC;Skip)

Ranking Umsatz MAT =

RANKX(Kreditoren;Kreditoren[Nettowert Mat je Kreditor];Kreditoren[Nettowert MAt je Kreditor];DESC;Skip)

As a result i need two colums with rankings per supplier but based on different value.

Is it simply impossible to have 2 calculated colums containing rankings within one table or is there another issue?

Greatful about any help!

[v-shex-msft · Accepted solution]

HI @gramespa ,

It seems like rankx function calculate on same contents and caused the issue, you can take a look at following links to know how to prevent circular dependency error.

Avoiding circular dependency errors in DAX

Regards,

Xiaoxin Sheng