Forum Discussion

Danfountain's avatar
Danfountain
Icon for Helper I rankHelper I
2 years ago
Solved

DAX with Filter and All together.

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...
Need Help
  • Gabriele_hbto's avatar
    Gabriele_hbto
    2 years ago

    try this 

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

Gabriele_hbto's avatar
Gabriele_hbto
Icon for Helper II rankHelper II
2 years ago

try this 

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

Danfountain's avatar
Danfountain
Icon for Helper I rankHelper I
2 years ago

Thank you.  I was obviously over complicating it!