Forum Discussion
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
- DallasBabaSkilled 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])) - aeinc01Frequent Visitor
Thank you! This worked. 😊