ALL not working

Hi amitchandak ,

Thanks for those.  Am applying the logic as suggested but I still can't get it to work 😞

Here is the model showing many-to-one relationships between the fact table and dim tables:

The measure I have used is:

TrendingHeadcount = 
VAR EOM = MAX(dim_PlacementDates[Date])
VAR SOM = MIN(dim_PlacementDates[Date])

RETURN

CALCULATE(DISTINCTCOUNT(fact_PlacementData[WamiKey]),
FILTER(fact_PlacementData,
(fact_PlacementData[HireDate]<= EOM && fact_PlacementData[TerminationDate]>=SOM) || 
(fact_PlacementData[HireDate]<= EOM && fact_PlacementData[TerminationDate]=BLANK())
),
ALL(dim_TerminationReasons)
) 

Here is the result of the measure with a MonthYear being selected and as you can see, it isn't producing the total against each row.

Then when I select a TerminationReasonDesc in the filter, it just gives me the result for that row and not the total result as desired.

Any ideas what I am doing wrong?

Thanks

Carl