Solved: Re: DAX Help

Anonymous · ‎05-06-2020

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.

Greg_Deckler · ‎05-06-2020

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Greg_Deckler · ‎05-06-2020

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Anonymous · ‎05-06-2020

@Greg_Deckler Thankyou so much.!

Greg_Deckler · ‎05-06-2020

You're welcome! 🙂

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...