Forum Discussion

SA800029's avatar
SA800029
New Member
8 years ago

Play Axis with time aggregation

Hi everybody,   I'm trying to show the evolution of individual peformances for the workers (Blue Colars / BC) in our plant. The point is to make sur it improves over time, and identify outilers wh...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi SA800029

 

You will just need to use measures that generate a cumulative value.

 

There are some good patterns to follow here  https://www.daxpatterns.com/cumulative-total/

 

Or if you share a little more about your tables, we can try and suggest some that may work for you.

SA800029's avatar
SA800029
New Member
8 years ago

Hi Phil,

 

Thank's for the website there're some useful patterns.

 

Unfortunately I'm still stuck with the play axis. When I try the formula without any filter on the dates, I get the same result than previously, which is good news, but as soon as I start to filter (using a slicer or the play axis), I get either nothing or an error.

 

Here are pictures of my data model and the error message I have when I use the column "Jour" (days in French) in the SOFI table for Play Axis.

 

 

 

 

For the Y axis I use a measure with the following formula :

The X axis being simply the sum of TAI.

 

Perfo OF = AVERAGEX(VALUES(SOFI[OF]);CALCULATE(DIVIDE(SUM(SOFI[TPP]);SUM(zz84[TAI]));zz84[OP TERA]<>""))

 

Is the problem with my model and the relationship may be ?

 

PS 1 : I added the table "WorkOrder" to get a unique Key, because the same WO can appear in several line in both tables. Due to the fact BC clock in at each step.

 

PS 2 : don't mind the other lines in the tables I only used the attributes mentionned earlier for this analysis.

 

Thank you for your help and let me know if you need more information, unforntunately I won't be able to share the tables as they contain confidential material on our personnel.

 

Regard,

 

Yoan

  • v-xjiin-msft's avatar
    v-xjiin-msft
    Solution Sage
    8 years ago

    Hi SA800029,

     

    Could you please share us your pbix file with One Drive or Google Drive if possible? So that we can dig deeper and make some proper tests.

     

    Thanks,
    Xi Jin.

    • SA800029's avatar
      SA800029
      New Member
      8 years ago

      Good afternoon,

       

      I prepared an anonym copy of my .pbix file so I can share it without any confidentiality breach, but I can't figure out how to join the document to my answer ?

      We have neither google drive nor one drive installed, for security measures, so installing them is not an option unfortunately.

       

      If you know how I can upload my files I'll do it gladly, otherwise I guess I'll have to hope someone can help me without it.

       

      Thank again for your time, I really appreciate

       

      Regard,

       

      Yoan