if else condition in dax

[Sathvik123]

Hello All,

I need help on below logic.

I have report where I am having data like below.

My requirement is in the report side I created a table having 3 values USA , UK and IND and then showing in slicer to select.

Now If I select slicer value as USA I need to show [USA/UK/IND] filed value as USA

If I select slicer value as UK I need to show [USA/UK/IND] filed value as UK

If I select slicer value as IND I need to show [USA/UK/IND] filed value as IND.

I created a measure like this and kept in filters of visuals to select 1 .

But its not working

1st Approach : ( Create a measure)

Picker filter =

var selected_value = SELECTEDVALUE(Country[Country])

var IND= if(max('GSD Stats'[USA/UK/IND])="IND",1,0)

var USA= if(max('GSD Stats'[USA/UK/IND])="USA",1,0)

var UK= if(max('GSD Stats'[USA/UK/IND])="UK",1,0)

return IF(

    selected_value = "USA",

    USA,

    IF(

       selected_value ="UK",

        UK,

    IF(

       selected_value ="IND",

        IND

)))

2nd approach: ( Create a column)

I created a column like this and kept in filters.

But its not working

Picker filter = SWITCH(

    TRUE(),

    [SelectedValue] = "IND", 'GSD Stats'[USA/UK/IND]="IND",

     [SelectedValue] = "USA", 'GSD Stats'[USA/UK/IND]="USA",

     [SelectedValue]  = "UK",'GSD Stats'[USA/UK/IND]="UK"

    )

[v-yiruan-msft · Accepted solution]

Hi @Sathvik123 ,

I created a sample pbix file(see the attachment), please check if that is what you want.

1. Create a measure as below 

Picker filter = 
VAR _selcountry =
    ALLSELECTED ( 'Country'[Country] )
VAR _seluui =
    SELECTEDVALUE ( 'GSD Stats'[USA/UK/IND] )
RETURN
    IF ( _seluui IN _selcountry, 1, 0 )

2. Create a table visual and apply a visual-level filter on the visaul with the condition(Picker filter is 1)

Best Regards

[FreemanZ]

hi @Sathvik123 

are you expecting the field parameter?

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

[Sathvik123]

Hi @FreemanZ ,

Not sure. How can I use this with parameters.

Could you please help