RANKX Not working if I add a new column

[Yonah]

Hi everyone,
I have a Matrix-Visual, that I'm using to rank my Article (Bezeichnung) by DB3_Lagerführend.
When it's only DB3_Lagerführend and Bezeichnung , the ranking is correct. 
This is the measure I'm using:
Artikel Rank =
RANKX (
ALLSELECTED ( 'Lagerführend'[Bezeichnung] ),
[DB3_Lagerführend],
,
DESC,
DENSE
)

 
See Picture below,

But as soon, as I add a second value, I get a wrong ranking.
See Picture below.

 

So, what is my mistake and is there a way to make sure that total is not rank.

Thanks

[mangaus1111]

Can you please send me sample data of all the columns of your source table?

[Yonah]

I found my mistack, if i creat the rank measure first an then use: 

IF(HASONEVALUE('Lagerführend'[Artikel]), [rank-measure]) it's working.

[mangaus1111 · Accepted solution]

Hi @Yonah ,

try this measure

Artikel Rank =

IF(

    HASONEVALUE('Lagerführend'[Artikel]),

    RANKX (

        ALLSELECTED ( 'Lagerführend' ),

        [DB3_Lagerführend],,

        DESC,

        DENSE

        )

)

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

[Yonah]

Hi,
if I'm using this measure all is rankd by 1.