Show goal amount for month when there is no revenue yet

[Anonymous]

Hi everyone,

I have my goals set up but if there is no revenue yet for the month, my goal card say (Blank).  I want to still see the goal amount even if there is no revenue yet.

Any suggestions would be great!

[aj1973]

Hi @Anonymous 

Add a measure to your model to calculate the revenue and then embed it into an IF measure. Use the IF measure into the card.

[Anonymous]

Thanks @aj1973 

I have my measure set up as

VAR _TOTALAMOUNT = SUM(Revenue[Amount])

RETURN

IF(ISBLANK(_TOTALAMOUNT) , 0 , _TOTALAMOUNT)

Goal value is still not showing up in my table for the state in question.
State            Amount       Goal
California         $0