Forum Discussion

Oros's avatar
Oros
Post Prodigy
5 years ago

Exclude items from TOPN

Hello.   I have a report with TOP N.  I created a new TOP TABLE and put the index top 5, top 10 and top 15.  I created a measure to add in the filter of the report: ITEM TOP in SelectedN = IF([IT...
Need Help
Oros's avatar
Oros
Post Prodigy
5 years ago

Hi Anonymous ,

 

Where exactly should I filter the items here?  Thanks.

 

ITEM RANKING = RANKX(ALL(Product_Table[Item]),Product_Table[Sales],, DESC)
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Oros 

 

try it

ITEM RANKING = RANKX(FILTER(ALL(Product_Table[Item]),Product_Table[Item])<>"yourItem1"&&Product_Table[Item])<>"yourItem2"),Product_Table[Sales],, DESC)
  • Oros's avatar
    Oros
    Post Prodigy
    5 years ago

    Hi Anonymous ,

     

    It does not look like it's working.  Maybe it's just missing some characters?

     

    Attached is the screenshot directly from Power Bi.  Just for the purpose of this example, I replaced the original table name to 'Product_Table'. Please ignore the spaces atthe beginning and end of 'Product_Table'.  But how it looks in Power Bi with the original table name is the same.

     

    Thanks.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Oros 

       

      Yes, && is missing between the two items, highlighted here

      ITEM RANKING = RANKX(FILTER(ALL(Product_Table[Item]),Product_Table[Item])<>"yourItem1"
&&
Product_Table[Item])<>"yourItem2"),Product_Table[Sales],, DESC)

       

      • Oros's avatar
        Oros
        Post Prodigy
        5 years ago

        Hello Anonymous ,

         

        Thank you for your reply.

         

        I tried it and still did not work.  The second item to exempt is greyed out.

         

        Please see attached.

         

        Thanks again.