Calculate Value with 2 condition

[rzilli]

Hi Everyone,

I am migrating our dashboards from Data Studio to Power BI but I'm having issue wiith DAX.

I used to use case function on Data studio when I want to Calculate 2 conditions but I need help in Power BI

I have a table sales, I need to calculate a bonus payment if the sales person achieve a determined amount and If he achieves a determined % margin.

I have 2 fiels that I created with Sum(Sales) and %Margin

In data studio we use

Case

When [Total sales] > 500000 and [% Margin] > 0.15 then [Bonus]

Else 0

End 

What is the function that I can use in Power BI??

Thank you

[Jihwan_Kim]

Hi,

Please try the below if it works.

Bonus =
SWITCH ( TRUE (), 
[Total sales] > 500000 && [% Margin] > 0.15, [Bonus], 
0 )