topic Re: Power BI version of 'Case When' using "Switch" Function in DAX Commands and Tips

Power BI version of 'Case When' using "Switch" Function

OneData — Thu, 02 Feb 2023 06:06:58 GMT

Hi guys - i'm new to dax and am having a bit oftrouble with what I would like to think should be something simple.

Essentially i have paramaters for each bucket listed below and I want those to dynammically fall into one column. I think I've done most of the hard part but I can't seem to put the right measure together. - Is this possible with a measure? I don't think i can add a numeric parameter in the calucalted column in power query so i'm kinda stuck here. Hopefully this is as simple for one of you as it would be for me in sql.

What am i doing wrong here?

ENLR Delta =

SWITCH(

TRUE(),

FILTER('Application','Application'[Fico Range] = "640-679"),([Net Loss Ratio] - [640-679 Value]),

FILTER('Application]','Application'[Fico Range] = "680-699"),([Net Loss Ratio] - [680-699 Value]),

FILTER('Application','Application'[Fico Range] = "700-739"),([Net Loss Ratio] - [700-739 Value]),

FILTER('Application','Application'[Fico Range] = "740-799"),([Net Loss Ratio] - [740-799 Value]),

FILTER('Application','Application'[Fico Range] = "800+"),([Net Loss Ratio] - [800+ Value]),

)

Re: Power BI version of 'Case When' using "Switch" Function

FreemanZ — Thu, 02 Feb 2023 05:25:17 GMT

hi OneData

what contexts do you have for the measure? Or how are you going to present this measure?

Re: Power BI version of 'Case When' using "Switch" Function

OneData — Thu, 02 Feb 2023 06:08:19 GMT

Similarly to case when - it will be presented in a single column - however for each bucket i need each desired input. I was able to accomplish this in power query during etl on a another column in the dataset but this one here depends on numeric parameters so i have to figure out a measure to accomplish the "case when" scenario

Re: Power BI version of 'Case When' using "Switch" Function

OneData — Thu, 02 Feb 2023 06:03:54 GMT

Fixed it - looks like instead of filter - using contains worked just fine for me - hope this helps someone in the future!

ENLR Delta =

SWITCH(

TRUE(),

CONTAINS('Application','Application'[Fico Range] = "640-679"),([Net Loss Ratio] - [640-679 Value]),

CONTAINS('Application]','Application'[Fico Range] = "680-699"),([Net Loss Ratio] - [680-699 Value]),

CONTAINS('Application','Application'[Fico Range] = "700-739"),([Net Loss Ratio] - [700-739 Value]),

CONTAINS('Application','Application'[Fico Range] = "740-799"),([Net Loss Ratio] - [740-799 Value]),

CONTAINS('Application','Application'[Fico Range] = "800+"),([Net Loss Ratio] - [800+ Value]),

)