What if parameter in DAX

[BarSi1986]

Dear All,
i want my "what if parameter" to affect only certain row in table - if the condidion is met (screen below), for example:

when i will hard code value of 20 inside DAX calculation it's working fine - there is 50 bikes in last column, but when im changing it to Extra bikes parameter value - nothing is happening, it doesn't see param value ....what am i doing wrong here ? 

[BarSi1986 · Accepted solution]

ok, i think i got this one ! switch statement with default parameter solved the problem of wrong totals 

[VahidDM]

HI @BarSi1986 

Try this measure:

Measure = 
Var _A =[Extra bikes Value]
return
if(max(Items[Item])="bikes",sum(Items[Quantity])-'Extra bikes'[Extra bikes Value],sum(Items[Quantity]))

Output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[BarSi1986]

Well, it fixed problem on row level here, but still doesn't affect TOTAL - we have 10+20 items, and the total of column is still 50, any ideas ? cause im still new in DAX 😞