DAX: Measure showing as blank in card but accurate in table

[Anonymous]

Hello, 

Trying to learn why this Measure "...Goal Selected" shows blank in card visual for me, when I want it to match what is in my table viz. My other measure works as expected. 

Net Operating Income Sum Total Goal Selected =

VAR Numerator =

 SUMX( 'Net Operating Income',

        CALCULATE('Net Operating Income'[Net Operating Income Cumulative Goal]

   , ALLSELECTED(Dates)) )

VAR FiscalPeriod = CALCULATE(MAX(Dates[Fiscal Month Number])

, ALLSELECTED( 'Dates')

, NOT ISBLANK('Net Operating Income'[Net Operating Income]))

RETURN

Numerator * FiscalPeriod

 

Net Operating Income Sum Total Selected = /* This measure works as I want it to and displays in card */ 

CALCULATE(SUM('Net Operating Income'[Net Operating Income]), ALLSELECTED(Dates))

Any ideas or posting that could help? Thanks!

[Anonymous · Accepted solution]

I figured out a solution that will work for now! Thank you.

Net Operating Income Sum Total Goal Selected =

VAR Numerator =

--SUMX( 'Net Operating Income', CALCULATE('Net Operating Income'[Net Operating

--Income Cumulative Goal], ALLSELECTED(Dates)) )

MIN( 'Net Operating Income Goal'[Net Operating Income] ) / 12

VAR FiscalPeriod = CALCULATE(MAX(Dates[Fiscal Month Number])

, ALLSELECTED( 'Dates')

, NOT ISBLANK('Net Operating Income'[Net Operating Income]))

VAR Result = Numerator * FiscalPeriod

RETURN

Result