Forum Discussion

qv's avatar
qv
New Member
2 years ago
Solved

Average Per day

I have done a bit of search in the forum & couldn't find scenario matching with one that I have got, hence this post. Scenario here is if I am running Daily/Magazine distribution centre and deliveri...
DAX AVERAGE
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi,

    I am not sure how your semantic model looks like, but please try something like below.

    I tried to create a sample pbix file like the attached file.

     

     

     

    expected result measure: = 
AVERAGEX(Data, 
    DIVIDE(Data[Time taken (in Mins)], Data[Days])
    )
Jihwan_Kim's avatar
Jihwan_Kim
Super User
2 years ago

Hi,

I am not sure how your semantic model looks like, but please try something like below.

I tried to create a sample pbix file like the attached file.

 

 

 

expected result measure: = 
AVERAGEX(Data, 
    DIVIDE(Data[Time taken (in Mins)], Data[Days])
    )