Divide a measure by a measure

[Anonymous]

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?

1.  CALCULATE(SUM(Hotel[Period 1 Hotel Booked Amount]),Hotel[Preferred Vendor Status]="Preferred")

2.  CALCULATE(SUM(Hotel[Period 1 Hotel Room Nights]),Hotel[Preferred Vendor Status]="Preffered")

Thank you!

[amitchandak · Accepted 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]

Hello,

It works.... I'm a fool. Spelled Preferred wong in my second formula.

Thanks for your help!

[ashamsuzzoha]

You can also add a third argument to divide() for what to return if you have division by 0.