Forum Discussion

Userpath77's avatar
Userpath77
Helper II
5 years ago
Solved

Modify Measure

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.
Need Help DAX
  • Tanushree_Kapse's avatar
    Tanushree_Kapse
    5 years ago

    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!

2 Replies

  • Tanushree_Kapse's avatar
    Tanushree_Kapse
    Impactful Individual
    5 years ago

    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!