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

Hi Anonymous ,

 

If you only want to add one dimension(Project), then you can try to use below method:

 

Create a new column :

Column = CALCULATE(COUNTROWS(Table1),ALL(Table1[Project]))

Then create the measure 2:

Measure 2 = SUM(Table3[HOURS]) / SUM(Table1[Column])
 
Thanks.
Aiolos Zhao
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello Anonymous 

 

Thank you for your reply.

 

I have tried the method below but it didn't work when I used filters of different periods like daily/weekly/monthly.

 

I suppose it is difficult to get information unless more detailed information is collected.

 

Best regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    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 getting back quickly.

       

      I will request further data to user and then may ask questions if I have. Thus, I am going to close this case.

       

      Thank you for your coopertation!

       

      Best regards,