Forum Discussion

JackWren's avatar
JackWren
Helper II
4 years ago
Solved

Rankx & Inscope while excluding certain values

Hi,    I'm currently trying to rank document's pages by the number of views they have.  I've successfully used rankx with inscope. However, I'm trying to remove the pages that are contain the word...
DAX
Help appreciated
isinscope
RANKX
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi JackWren ,

     

    Please try this measure.

    Top Page - Views = 
IF (
    ISINSCOPE ( 'Page Info'[PageName] )
        && MID ( MAX ( 'Page Info'[PageName] ), 12, 4 ) = "Page",
    RANKX (
        ALLSELECTED('Page Info'[PageName]),
        CALCULATE( SUM ( 'Page Info'[Total page Views] )),
        ,
        DESC,Dense
    ) - 1
)

    Best Regards,
    Community Support Team_Gao

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi JackWren ,

 

Please try this measure.

Top Page - Views = 
IF (
    ISINSCOPE ( 'Page Info'[PageName] )
        && MID ( MAX ( 'Page Info'[PageName] ), 12, 4 ) = "Page",
    RANKX (
        ALLSELECTED('Page Info'[PageName]),
        CALCULATE( SUM ( 'Page Info'[Total page Views] )),
        ,
        DESC,Dense
    ) - 1
)

Best Regards,
Community Support Team_Gao

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

  • JackWren's avatar
    JackWren
    Helper II
    4 years ago

    Thank you ! I'll tweak it a little but I think we are headed in the right direction