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.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |