Slicer help with OR filter

[RiverDreams]

Hi,

I am new here and it's my second month of using Power BI as an intern. Sorry if this has been posted already or resolved but I am not able to put this in to Power BI as sames as what I did in Excel.

I want to create a slicer in Power Bi desktop to filter my table.

Slicer has 2 selection Australia and NZ

My source basically has a column with 0, 1 and 2 entered as data.

What I want is, if I clicked on NZ on the slicer it will filter and show all data with 1 on them.

If I clicked on Australia it will filter 1 and 2 only (not including 0).

I know it seems so basic, but I hope you can help me with this.

Many thanks

River

[mussaenda]

Welcome to Power BI!

Please provide sample data and desired output to help you easier.

Thank you!

[RiverDreams]

dataNZ filters all status 1Australia filters all status 1 and 2

[v-diye-msft · Accepted solution]

Hi @RiverDreams ,

Please let me know if you'd like to get below result: 

NewStatus = IF(SELECTEDVALUE('Table (2)'[Column1]) = "Australia",CALCULATE(MAX('Table'[Status]),FILTER('Table',[Status]=1)),IF(SELECTEDVALUE('Table (2)'[Column1])="NZ",CALCULATE(MAX('Table'[Status]),FILTER('Table',[Status]=1||[Status]=2)),MAX('Table'[Status])))

Pbix attached.

[mussaenda]

This Result is based on your data screenshot. This is your desired output?

[RiverDreams]

@mussaenda 

Yes this is the exact output that I am looking for. What is the best approach on this? Thanks