How to exclude other rows I don't want?

[YunJ]

Hi,

I wrote a measure.

When slicer Category="Makeup", the Store would be MNY, 3CE, LRL MU.

When slicer Category="Skincare", the Store would be LRL FSS, MG, SGMB.

Then I want to rank them from all the store names, so I wrote a RANKX measure as following.

The problem is, the rank numbers for those 3 stores per category are correct, but why other stores also show here? 

Is there any solution to exclude other stores?

Thanks a lot for your time!

[V-lianl-msft · Accepted solution]

Hi @YunJ ,

Try to create a measure and apply it in the visual level filter.

if(not(isblank(measure))),1,0)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[YunJ]

Hi @V-lianl-msft 

It seems like I can simply put "measure is not blank" to the Filter Pane. 

Thanks a lot for your solution!

[amitchandak]

@YunJ , Try like

measure = calculate(sum(Blue[GV]), filter(Blue,
(Blue[Category]="Makeup" && Blue[Store] in {"MNY", "3CE", "LRL", "MU"}) ||
(Blue[Category]="Skincare" && Blue[Store] in {"LRL", "FSS", "MG", "SGMB"})
))

[YunJ]

Hi @amitchandak 

Thanks for your reply.

Actually the Category is in Category table, and the Store is in Store table. I made relationships for those two and the blue table.

Also, I already successfully wrote a sum(GMV) measure, only cannot write a RANKX measure for the selected Category and Store.

Thanks for your time.