Return blank values based where measure has a value greater than the x axis.

[MattWoodley]

Hi, 

I am trying to return Blank values for the 'Pool Origination' measure where the 'Max Term 1' measure is greater than the term run on the x axis 'Term Run'[Term Run]. 

I've tried a bunch of different options but none seem to work... The two related measures are below. 

Appreciate any ideas.

Pool Origination = CALCULATE (

SUM('Unique Account Numbers'[Amount Financed]),

ALLSELECTED('Term Run'[Term Run])

)

Max Term 1 =

 CALCULATE (

    MAX('Unique Account Numbers'[Term Run]),

    ALLSELECTED('Term Run')

    )

[v-kkf-msft]

Hi @MattWoodley ,

Please try the measure.

Pool Origination = 
VAR _sum =
    CALCULATE (
        SUM ( 'Unique Account Numbers'[Amount Financed] ),
        ALLSELECTED ( 'Term Run'[Term Run] )
    )
RETURN
    IF ( MAX ( 'Term Run'[Term Run] ) >= [Max Term 1], _sum )

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@MattWoodley , based on what I got

if(max('Term Run'[Term Run]) > calculate(MAx('Term Run'[Term Run]), allselected()) ,blank(), max('Term Run'[Term Run]))