Forum Discussion

aeinc01's avatar
aeinc01
Frequent Visitor
2 years ago
Solved

Simple DAX Query not calculating correctly.

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. 

  • 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]))

2 Replies

  • DallasBaba's avatar
    DallasBaba
    Skilled Sharer

    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]))