Forum Discussion

Floriankx's avatar
Floriankx
Icon for Solution Sage rankSolution Sage
8 years ago
Solved

Rankx filter empty cells

Hello together,   I'm struggling with creating rank for projects when project cell is empty.   Project order value OrderRank Project 1 100 $10.000 1   101 $250.000 5 Project ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Floriankx

     

    Try this MEASURE

     

    ProjectLevelRank =
IF (
    NOT ( SELECTEDVALUE ( fOrders[Project] ) = BLANK () ),
    RANKX (
        FILTER ( ALLSELECTED ( fOrders[Project] ), fOrders[Project] <> BLANK () ),
        CALCULATE ( SUM ( fOrders[value] ) ),
        ,
        ASC,
        DENSE
    )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Floriankx

 

Try this MEASURE

 

ProjectLevelRank =
IF (
    NOT ( SELECTEDVALUE ( fOrders[Project] ) = BLANK () ),
    RANKX (
        FILTER ( ALLSELECTED ( fOrders[Project] ), fOrders[Project] <> BLANK () ),
        CALCULATE ( SUM ( fOrders[value] ) ),
        ,
        ASC,
        DENSE
    )
)
Floriankx's avatar
Floriankx
Icon for Solution Sage rankSolution Sage
8 years ago

Hello Zubair_Muhammad,

 

Amazing! It works, I would never have figured this out by myself.

 

unfortunately SELECTEDVALUE isn't available to me, so I had to rephrase it with IF(HASONEVALUE(<column>);Values(<column))

Maybe I will find the time to understand this formula entirely.

 

Best regards.