Need to calculate days since last OSHA incident in a few areas

[AsatorEgnor]

I used the following custom column that @Anonymous made in a different post to create a column in order to calculate the days between the last OSHA recordable 

"Days since incident =
IF(
Safety_Incidents[OSHA Incidents] = "Yes",
DATEDIFF(
CALCULATE(
MAX( Safety_Incidents[Date of Incident]),
FILTER(Safety_Incidents, Safety_Incidents[Date of Incident] < EARLIER(Safety_Incidents[Date of Incident] )),
FILTER(Safety_Incidents, Safety_Incidents[OSHA Incidents] = "yes")
),
Safety_Incidents[Date of Incident],
Day
),
Blank ()
)"

It worked great, but when I create a table it only shows the areas for the current month in the slicer and I would like for it to show total between incidents regardless of the slicer so it can be cumulative. 

Any suggestions?

[Anonymous · Accepted solution]

Hi @AsatorEgnor ,

Please create a new measure:

Days since last OSHA =
VAR __max_date =
    MAX ( 'Date'[Date] )
VAR __result =
    CALCULATE (
        SUM ( 'Safety_Incidents'[Days since incident] ),
        'Date'[Date] <= __max_date
    )
RETURN
    __result

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Greg_Deckler]

@AsatorEgnor Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.