Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
rzilli
Frequent Visitor

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

 

 

 

 

1 REPLY 1
Jihwan_Kim
Super User
Super User

Hi,

Please try the below if it works.

 

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.