Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX Help

Expired = CALCULATE(COUNT('Card Type'[CardType]) ,FILTER('Card Type' , IF([End Date] > 'Card Type'[GracePeriodEndDate] ,1,0))) I want 0 for rows that are not satisfying the filter condition. Wha...
General Comment
Interesting Links
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago
    Anonymous

    I think:

    Expired =
    VAR __Expired = CALCULATE(COUNT('Card Type'[CardType]) ,FILTER('Card Type' , IF([End Date] > 'Card Type'[GracePeriodEndDate] ,1,0)))
    RETURN IF(ISBLANK(__Expired),0,__Expired)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago
Anonymous

I think:

Expired =
VAR __Expired = CALCULATE(COUNT('Card Type'[CardType]) ,FILTER('Card Type' , IF([End Date] > 'Card Type'[GracePeriodEndDate] ,1,0)))
RETURN IF(ISBLANK(__Expired),0,__Expired)
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Greg_Deckler Thankyou so much.!

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      6 years ago
      You're welcome! 🙂