Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I don't know if this is the best way to go about this. I'm sure I could get this all done in the orginal formula, but I will explain what I have. Below I have two formulas that I need to divide formula 1 by formula 2. I'm gettting an infinte number when trying to do a simple =Divide(Measure1,Measure2).
Can anyone help me with this?
Solved! Go to Solution.
@Anonymous , this should work
measure 1= CALCULATE(SUM(Hotel[Period 1 Hotel Booked Amount]),Hotel[Preferred Vendor Status]="Preferred")
measure 2 CALCULATE(SUM(Hotel[Period 1 Hotel Room Nights]),Hotel[Preferred Vendor Status]="Preffered")
Measure 3 = divide([measure1],[measure2])
@Anonymous , this should work
measure 1= CALCULATE(SUM(Hotel[Period 1 Hotel Booked Amount]),Hotel[Preferred Vendor Status]="Preferred")
measure 2 CALCULATE(SUM(Hotel[Period 1 Hotel Room Nights]),Hotel[Preferred Vendor Status]="Preffered")
Measure 3 = divide([measure1],[measure2])
Hello,
It works.... I'm a fool. Spelled Preferred wong in my second formula.
Thanks for your help!
You can also add a third argument to divide() for what to return if you have division by 0.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
87 | |
80 | |
69 | |
69 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |