DAX with Filter and All together.

[Danfountain]

Hi all,

I have these two DAX measures that seem to work as intended.

So this one counts all of the records that are deleted:

Mapping_Count = CALCULATE(

      COUNT(FACT_Mapping[MappingId]), FILTER(FACT_Mapping,'FACT_Mapping'[isdeleted]=FALSE))

And this one counts all of the records removing the calendar filter.

Mapping_Total = CALCULATE(

      COUNT(FACT_Mapping[MappingId]), ALL(CalendarTable)

)

Now I need a further measure that comibines the two (but with the isdeleted the other way around).  Remove the filter on the calendar table but only count the deleted.  This is what I have.... 

Mapping_Total_DELETED = CALCULATE(

      COUNT(FACT_Mapping[MappingId]),ALL(CalendarTable), FILTER(FACT_Mapping,'FACT_Mapping'[isdeleted]=TRUE))

But effectively the ALL(Calendar) table bit isnt working as intended as its still filtered based on the calendar table. 

Any ideas?

TIA

Dan

[Gabriele_hbto · Accepted solution]

try this 

Mapping_Total_DELETED = CALCULATE(
COUNT(FACT_Mapping[MappingId]),
ALL(CalendarTable),
'FACT_Mapping'[isdeleted] = TRUE
)

[Danfountain]

Thank you.  I was obviously over complicating it!