Measure logical issue

[Anonymous]

Hi,

We are facing logical issue in the measure. Our problem statement is daily utilisation % over time & when we tried calculation in dax query the values are different.

Formula = Total volume done/(Target productivity * Days worked * Employee who worked)

When we drill down month wise, we are getting..

YTD value & month value is different.

Can you help me to fix this problem..

@Anonymous 

[Anonymous]

Hi @Anonymous,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , Are these measures or columns Ideally it should like using columns

Formula =

divide( Sum(Table[Total volume done], Sumx(Table, Table[Target productivity] * Table[Days worked] * Table[Employee who worked] ))

Or force multiplication on the group if these are a measures

Divide([Total volume done], sumx(Values(Table[Month Year]) , [Target productivity] * [Days worked] * [Employee who worked] ) )