Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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



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

Else 0



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




Thank you





Super User
Super User


Please try the below if it works.


Bonus =
[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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors