Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dealing with missing rows in underlying data, and adding 0 values

To put it simply our database is calculating 40 metrics for thousands of projects on a daily basis. Each row in the database has project ID, metric type, value, and date. To save on performance our d...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Anonymous - OK, what column are you using in the axis of your Line chart then?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I'm using the date column, more specifically the date hierarchy with months, and years. 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Anonymous - OK, can you post the measure formulas that we created? I should be able to tell what is going haywire if I have those.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Sure thing!

       

      Measure 13 = var testmeasure1 = AVERAGE('CSDB project_metric'[Work at Height])
      RETURN
      IF(ISBLANK(testmeasure1),0,testmeasure1)
       
      Measure 14 =
      VAR TABLE1 = SUMMARIZE('CSDB project','CSDB project'[id],"Work at height test",[Measure 13])
      return
      if(HASONEVALUE('CSDB project'[id]),[Measure 13],AVERAGEX(TABLE1,[Work at height test]))
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Greg_Deckler 

         

        Any luck with this? Is there anything else I can provide?

         

        Again, your help is greatly, greatly appreciated.