Modify Measure

[Userpath77]

Hello All

I have this measure and using it in a card, that card gets filtered and when no values present it says "blank." I need to modify the measure so that it returns a "0" if no values present. How should this be re-written?

CALCULATE(countrows(Elig_List),filter(Elig_List,Elig_List[Prom Elig Date]-TODAY()<=45))

Thanks for any help.

[Userpath77]

Thank you......worked perfect!

[Tanushree_Kapse · Accepted solution]

Hi @Userpath77 ,

Just add 0 at the end of the measure and you are good to go!
CALCULATE(countrows(Elig_List),filter(Elig_List,Elig_List[Prom Elig Date]-TODAY()<=45))+ 0

Kudos are always appreciated!