https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Incident-Rate-Measure-Help/m-p/474012#M156546 <P class="lia-message-dates lia-message-post-date lia-component-post-date-last-edited"><SPAN class="DateTime lia-message-posted-on lia-component-common-widget-date"><FONT color="#999999">&nbsp;Hello,</FONT></SPAN></P><P>&nbsp;</P><DIV class="lia-message-body lia-component-body"><DIV class="lia-message-body-content"><P>I am trying to calculate the incident rate by recordable incidents in Power Bi. I have it specified to pull the recordable incidents, but in the calculation I am using it is totaling all hours over all years. I need to know how to tell the function to only do YTD total or specify the calculation by year.</P><P>&nbsp;</P><P>This is the measure I came up with</P><P>TRR = COUNT(IncidentReports[SeverityType])*200000/(SUMX(HoursWorkedCompilation,HoursWorkedCompilation[Manhours]))</P><P>&nbsp;</P><P>The Hours Worked Table has multiple columns, the column is is pulling from has Man Hours. There is a separate column that specifies the year, but I cannot figure out how to tell it to do that.</P><P>&nbsp;</P><P>HELP!</P></DIV></DIV> Fri, 27 Jul 2018 16:38:11 GMT Alliejane08 2018-07-27T16:38:11Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Incident-Rate-Measure-Help/m-p/474012#M156546 <P class="lia-message-dates lia-message-post-date lia-component-post-date-last-edited"><SPAN class="DateTime lia-message-posted-on lia-component-common-widget-date"><FONT color="#999999">&nbsp;Hello,</FONT></SPAN></P><P>&nbsp;</P><DIV class="lia-message-body lia-component-body"><DIV class="lia-message-body-content"><P>I am trying to calculate the incident rate by recordable incidents in Power Bi. I have it specified to pull the recordable incidents, but in the calculation I am using it is totaling all hours over all years. I need to know how to tell the function to only do YTD total or specify the calculation by year.</P><P>&nbsp;</P><P>This is the measure I came up with</P><P>TRR = COUNT(IncidentReports[SeverityType])*200000/(SUMX(HoursWorkedCompilation,HoursWorkedCompilation[Manhours]))</P><P>&nbsp;</P><P>The Hours Worked Table has multiple columns, the column is is pulling from has Man Hours. There is a separate column that specifies the year, but I cannot figure out how to tell it to do that.</P><P>&nbsp;</P><P>HELP!</P></DIV></DIV> Fri, 27 Jul 2018 16:38:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Incident-Rate-Measure-Help/m-p/474012#M156546 Alliejane08 2018-07-27T16:38:11Z