Forum Discussion

rzilli's avatar
rzilli
Frequent Visitor
4 years ago

Calculate Value with 2 condition

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

 

 

 

 

Need Help

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    4 years ago

    Hi,

    Please try the below if it works.

     

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