Selected value with two selections in IF

[Anonymous]

Hi everyone,

I have a line and combo chart with the line value having the Dax eq, if(selected value = a, [average speed], if(selected value = b, [average speed], blank ())), that all works fine.
However I now also want to add if(selected value= a & b & c ,[average speed], I can't get this to work.

Thank you in advance

[Anonymous · Accepted solution]

Hi, @Anonymous 

Can you make the question clear, what do you mean you it doesn't work(dose it return an error or just blank)? 

Because for if(selected value= a & b & c ,[average speed], the formula should be correct. It returns a value when the lookupcolumn has a cell that is "abc". 

BTW, If you wanted to put them in one IF function:

IF([SelectValue]="a"||[SelectValue]="b"||[SelectValue]="c",[Average Speed])

Best,

Paul

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.