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
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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Oros 

     

    There is a hint, the syntax "," is not correct. You may to go to format your DAX code and try to find out your problem. Or I will pm you my email, you can send me your DAX measure or sample file if you want.

    https://www.daxformatter.com/