Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Line Chart not plotting for all Dates

Hi,   I have the following measure that calculates an InjuryRate:  InjuryRate = Calculate(Countrows(IncidentReports);IncidentReports[Incident Classification]="XYZ")*1000000/[TotalManHour]   So, ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi Anonymous 

    If so, you may try this formula instead of [TestMeasure]

    New TestMeasure = CALCULATE([Long Time Injury Frequency Rate],FILTER(ALL(APier_DateTable),APier_DateTable[Date]<=MAX(APier_DateTable[Date])))

    Please replace ',' with ';' when your copy the formula.

     

    Regards,

    Lin

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous 

 

Thank you for the response, but I believe this does not really answer my question.

 

In the table view above, I would like the measure to be calculated for all dates on each row.

So, I would actually like to plot the date against the value that appears in the 'Total' row in the table above.

 

Based on your responde I tried the below and could get the desired line chart by plotting date against the below measure:

     TestMeasure = TOTALYTD([Long Time Injury Frequency Rate];APier_DateTable[Date])
 
Which now correctly gives me the below desired line chart:

 

 

However, I realise this is only working because all my data is within the 2019 year. This function will no longer work once we start gathering data on 2020.

 

Is there an alternative way for me to produce the above line chart?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sorry the above was for v-lili6-msft