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

Whitewater100's avatar
Whitewater100
Solution Sage
4 years ago

Hi:

Can you duplicate or reference this table in Power Query and Filter out there? Then apply your ranking measure on new table? Because it seems like a number of pages to get rid of I suggest PQ.

 

If some index could be asigned to these types of pages upfront that could help down the road.

 

Just my thoughts on this. Someone else may have a unqiue way, which is easier if it's just one type of word you are trying to avoid.

 

Hope this helps..

  • JackWren's avatar
    JackWren
    Helper II
    4 years ago

    Sorry for the delay, you might be right. I'll try doing it directly in the table instead of using Dax. 

     

    Thank you 🙂