Need help with if statement

[Jay2077]

Say my power bi report featues a drop down of items and item 'A' comes under both the 'new' and 'budget' sections on a different drop down. 

How do I make it so the items comes under one of those depending on the filter witrhout designating the item to only one section? Also most other items are only under one section?

Any help greatly appreciated.

[v-easonf-msft]

Hi,  @Jay2077 

Not  very clear. Can you provide your sample file for further research?

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Jay2077 , I doubt you have to create a new column and there item A should be in one category