Forum Discussion

ibuhary's avatar
ibuhary
Icon for Helper I rankHelper I
7 years ago
Solved

Remove RANKX from Total Row and Hide from Non Related Filters

Hello everyone,   I have the few Created Measures in my Database:   - StoreRank = RANKX(ALL(Table[Store Code],Table[Store Name]),CALCULATE(SUM(Table[Sales Volume])),,DESC)    - ProductRank = RA...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    ibuhary

     

    For your first question, you can use HASONEFILTER to detect totals/subtotals

     

    Something like this

     

    - StoreRank =
IF (
    HASONEFILTER ( Table[Store Code] ),
    RANKX (
        ALL ( Table[Store Code], Table[Store Name] ),
        CALCULATE ( SUM ( Table[Sales Volume] ) ),
        ,
        DESC
    )
)
ibuhary's avatar
ibuhary
Icon for Helper I rankHelper I
7 years ago

Did I ask something not logical to do in Power BI ?

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    7 years ago

    ibuhary

     

    For your first question, you can use HASONEFILTER to detect totals/subtotals

     

    Something like this

     

    - StoreRank =
IF (
    HASONEFILTER ( Table[Store Code] ),
    RANKX (
        ALL ( Table[Store Code], Table[Store Name] ),
        CALCULATE ( SUM ( Table[Sales Volume] ) ),
        ,
        DESC
    )
)
    • ibuhary's avatar
      ibuhary
      Icon for Helper I rankHelper I
      7 years ago

      can you help me on another issue please ?