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.
What else i can use instead of "FILTER" to get the result.
 
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)

4 Replies

  • 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)