topic Re: Nested IF's in DAX with text and parameters in DAX Commands and Tips

Nested IF's in DAX with text and parameters

Anonymous — Thu, 19 Mar 2020 11:02:58 GMT

Hi all,

I'm stuck and hope the community can help me.

Simple problem. A table contains:

Fruit Value

Orange 10

Apple 4

Banana 20

Strawberries 7

I have a % parameter (so 0% to 100%) which is selected by the user.

I need a new column with the logic of:

If Fruit = Orange then (Value * % parameter + 10) or;

If Fruit = Apple then (Value * % parameter + 5) or;

If Fruit = Banana then (Value * % parameter + 2)

otherwise return Value

I relatively new to PowerBI so am struggling with nested IF searching for texts and returning a formula. I've looked at many examples but currently haven't got it.

All help welcome. Thanks a lot in advance.

Re: Nested IF's in DAX with text and parameters

az38 — Thu, 19 Mar 2020 11:49:56 GMT

Hi Anonymous

try this technique

Measure = var _parameter = DIVIDE(SELECTEDVALUE('Table'[Parameter]), 100) var _fruit = SELECTEDVALUE('Table'[Fruit]) var _valueParameter = SELECTEDVALUE('Table'[Value])*_parameter RETURN SWITCH(TRUE(), _fruit = "Orange", (_valueParameter + 10), _fruit = "Apple", (_valueParameter + 5), _fruit = "Banana", (_valueParameter + 2) )

Re: Nested IF's in DAX with text and parameters

Anonymous — Thu, 19 Mar 2020 13:18:34 GMT

Thank you for the superfast reply! Yes, the format with some tweaking worked and I learnt a lot on the way.

Really appreciated!

Re: Nested IF's in DAX with text and parameters

Anonymous — Thu, 19 Mar 2020 17:49:02 GMT

Actually, sorry still stuck. When I use the following with a a whatif parameter, the correct values are returned.

Apple = ((620)*Parameter[Parameter Value])+((750)*(1-Parameter[Parameter Value]))

However, if I wanted to simply subtract that result from another number , the results are incorrect. So for example:

Apple = 750 - ((620)*Parameter[Parameter Value])+((750)*(1-Parameter[Parameter Value]))

Clearly I'm missing something so basic but has stumped me. Any suggestions again would be appreciated

Many thanks.

Re: Nested IF's in DAX with text and parameters

az38 — Thu, 19 Mar 2020 18:21:21 GMT

Anonymous

sorry, I do not understand the issue

also, please set @ in message and choose my login in drop down list to notify me about reply