Finding actual numbers with varying dates status'

[anna-lee]

Hi,

I'm trying to calculate the sum of the projected total value for each employees across several regions. The aim is to sum the Salary column where the Status column is active up until the Salary value for a given active Month is 0, then give the inactive Salary value afterwards for each Employee and Region. The 'Projected Total Value' column is what my end goal is whether it be a measure or calculated column. 

Sample Data 

[Abhinav054]

hii, once try this DAX expression

Projected Total Value = CALCULATE( SUM(
                                             CASE
                                                                WHEN Status = "Active" THEN Salary
                                             ELSE
                                                     CASE WHEN StatusMonth <= LastActiveMonth THEN 0 ELSE InactiveSalary                                                  END
                                              END),
                                                    FILTER( table,
                                                                   table[Status] = "Active")
)

[anna-lee]

@Abhinav054 
Hello! Thank you for your response. I think I'm missing a couple of steps prior as you're referencing LastActiveMonth and Inactive Salary. Do you mind sharing the pbix file?