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