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 presen...
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!

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!