Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Measure logical issue

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 

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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