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 your reply.

 

I have tried the measure but it didn't work when I put the measure into project table below. I guess it is a problem that Table 1 (Project) contains duplicated projects as it is sorted by date.

This can be filtered by the time slicer by monthly/weekly/daily.

 

 

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

As you mentioned, currently, there is no data about date in Table 3 (ID and employee).

 

If you have any idea or suggestion, could you please let me know.

 

Thank you.

 

 

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,