Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Yonah
Helper II
Helper II

Rankx with condition not working

Hi,
so I have a very strange Problem, I try to Rank Products but only if they have five Points.
But I get this result 

WROMG.PNG

So it looks like even if the Product 3 still get a Rank, even if at has only 4 Points.
So the Result I want should be something like

BezeichnungRank
11
22
3 
43


The DAX for checking for the Points is:

 

01_Punkte =
VAR SUM_DB3 =
    SUM ( '01 Lagerführend'[DB3] )
VAR SUM_DB3_pro_Stueck = [00_DB3_pro_Stück]
VAR SUM_Rendite = [Rendite Lagerführend 100]
VAR SUM_Retouren = [Umsatz Retouren Quote]
VAR SUM_Menge =
    SUM ( '01 Lagerführend'[Menge] )
VAR SUM_Parameter_DB3 =
    SUM ( '03 DB3'[Parameter] )
VAR SUM_Parameter_DB3_pro_Stueck =
    SUM ( '03 DB3 pro Stück'[DB3 pro Stück] )
VAR SUM_Parameter_Rendite =
    SUM ( '03 Rendite Lagerführend'[Rendite Lagerführend] )
VAR SUM_Parameter_Retouren =
    SUM ( '03 Retouren'[Retouren] )
VAR SUM_Parameter_Menge =
    SUM ( '03 Menge Lagerführend'[Menge Lagerführend] )
VAR CHECK_DB3 =
    IF ( SUM_DB3 >= SUM_Parameter_DB3, 1, 0 )
VAR CHECK_DB3_pro_Stueck =
    IF ( SUM_DB3_pro_Stueck >= SUM_Parameter_DB3_pro_Stueck, 1, 0 )
VAR CHECK_Rendite =
    IF ( SUM_Rendite >= SUM_Parameter_Rendite, 1, 0 )
VAR Check_Retouren =
    IF ( SUM_Retouren <= SUM_Parameter_Retouren, 1, 0 )
VAR Check_Menge =
    IF ( SUM_Menge >= SUM_Parameter_Menge, 1, 0 )
VAR Sum_Check = CHECK_DB3 + CHECK_DB3_pro_Stueck + Check_Menge + CHECK_Rendite + Check_Retouren
VAR Punkte = Sum_Check
RETURN
    Punkte

 

The DAX for the Ranking is:

 

02_Ranking =
VAR __Table =
    ADDCOLUMNS ( ALLSELECTED ( '01 Lagerführend' ), "__Punkte", [01_Punkte] )
VAR Ranking =
    IF (
        AND ( HASONEVALUE ( '01 Lagerführend'[Bezeichnung] ), [01_Punkte] = 5 ),
        RANKX (
            ALLSELECTED ( '01 Lagerführend'[Bezeichnung] ),
            [DB3_Lagerführend],
            ,
            DESC
        ),
        ""
    )
RETURN
    Ranking

 

 

Here is a Link to a sample file.
https://clptradinggmbh699-my.sharepoint.com/:f:/g/personal/aust_clptradinggmbh699_onmicrosoft_com/Ep...


Thanks

3 REPLIES 3
mangaus1111
Solution Sage
Solution Sage

Hi @Yonah ,

try to select Don't Summarize here.

mangaus1111_0-1667836464305.png

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

 

It's stays the same. 

Hi @Yonah ,

see my pbi file. It seems it works

https://1drv.ms/u/s!Aj45jbu0mDVJi0KpWsicFQTid58u?e=AqA84f

 

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors