Simple DAX Query not calculating correctly.

[aeinc01]

Hi,

I'm looking on for an answer why my DAX query isn't calcualtiing correctly. Currently this is the query I'm using, simply trying to calcualte utilization, i.e. realized/booked_to_run:

Utilization = DIVIDE(

SUMX('DW_H_POD', 'DW_H_POD'[billable_rate] * 'DW_H_POD'[hours]), SUM('DW_H_POD'[billable_rate])

)

However, I'm getting a completley differnt total. For example 

Realized is 35,285/14,440  and I'm getting 1.95 instead of 2.44. 

Any suggestions will be much appreciated. 

Thanks. 

[aeinc01]

Thank you! This worked. 😊

[DallasBaba · Accepted solution]

Hi @aeinc01 

Do you have a columns for realized value ? Is so try
Utilization = DIVIDE(SUM('DW_H_POD'[realized]), SUM('DW_H_POD'[booked_to_run]))