Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Create daily AVERAGE Measure by condition

Hello,   I am struggling with creating a measure of daily average by condition. Would you please help me with creating a measure.   Now I have data below.   I would like to calculate aver...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous ,

     

    Yes, like you said, maybe if you can support more sample data, then I will try to figure out the issue.

    Thanks.

    Aiolos Zhao

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello Anonymous ,

 

Thank you for reply.

 

Here are the model of data about each table.

 

And I would like to calculate like below. I tried to use AVERAGE in hours with COUNT of project but it didn't work.

 

 

If you need more information, please let me know.

 

Best regards,

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

 

I think I got what you want:

Measure = SUM(Table3[HOURS]) / CALCULATE(COUNTROWS(Table1),ALL(Table1[Project]))

I think the key point to solve this problem is to get the same date between table 1 and table 3.

If you can't get that, could you please give some sample with different date, so I can try to figure out it.

Thanks.

Aiolos Zhao