Forum Discussion

RiverDreams's avatar
RiverDreams
Frequent Visitor
7 years ago
Solved

Slicer help with OR filter

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...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    7 years ago

    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.

RiverDreams's avatar
RiverDreams
Frequent Visitor
7 years ago

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

v-diye-msft's avatar
v-diye-msft
Community Support
7 years ago

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.