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

Hello v-luwang-msft ,

 

Thank you for your reply.

 

I am getting the error a circular dependency was detected when I followed Step 1.

 

Any ideas?

 

Thanks.

v-luwang-msft's avatar
v-luwang-msft
Community Support
5 years ago

Hi Oros ,

Could you pls share your pbix file ?And change confidential data to sample data.

This may vary due to differences in the underlying data and will need to be adjusted to your specific file. 

 

 

Best Regards

Lucien

  • Oros's avatar
    Oros
    Post Prodigy
    5 years ago

    Hi v-luwang-msft ,

     

    Thank you for your reply.  Unfortunately the data is too big.

    • v-luwang-msft's avatar
      v-luwang-msft
      Community Support
      5 years ago

      Hi Oros ,

      Test the below,and don not forget change the tablename (if Item data type is number) :

      TEST =
RANKX (
    FILTER (
        ValueEntries,
        ValueEntries[Item] <> 1623
            && ValueEntries[Item] <> 5435
    ),
    ValueEntries[Sales],
    ,
    DESC,
    DENSE
)

       if Item data type is text:

      TEST =
RANKX (
    FILTER (
        ValueEntries,
        ValueEntries[Item] <> "1623"
            && ValueEntries[Item] <> "5435"
    ),
    ValueEntries[Sales],
    ,
    DESC,
    DENSE
)

       

       

      Wish it is helpful for you!

       

       

      Best Regards

      Lucien

      • Oros's avatar
        Oros
        Post Prodigy
        5 years ago

        Hi v-luwang-msft ,

         

        Unfortunately the first TES measure gives this error.

         

        The second TEST measure did not give error BUT lost all the top items.  All items show instead of just the selected top (5, 10, 15, 20...).  Hundreds of items show.

         

        Any ideas?

         

        Thanks.