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

v-lili6-msft's avatar
v-lili6-msft
Community Support
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

v-lili6-msft perfect, thank you!