topic Re: Modify Measure in DAX Commands and Tips

Modify Measure

Userpath77 — Thu, 15 Jul 2021 12:58:12 GMT

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.

Re: Modify Measure

Tanushree_Kapse — Thu, 15 Jul 2021 13:18:25 GMT

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!

Re: Modify Measure

Userpath77 — Thu, 15 Jul 2021 19:29:44 GMT

Thank you......worked perfect!