I need help on blanks instead of zeros in my calculations

[Anonymous]

Can 

GYM = AVERAGE('JMH'[GYM])

GYM ii = AVERAGE( 'General'[GYM])

GYM Results= CALCULATE(IF([GYM] >= 0, ['JMH' GYM], [GYM ii] ) )

Thank you

I have even tried this one too: 

GYM Results= if( [GYM ii] >=0, [GYM ii], if( [GYM] >=0, [GYM],  blank( ) )

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Measures

avg1 = SUM('Table (3)'[cl2])/CALCULATE(COUNT('Table (3)'[cl1]),ALLEXCEPT('Table (3)','Table (3)'[cl1]))

avg2 = SUM('Table (4)'[cl2])/CALCULATE(COUNT('Table (3)'[cl1]),ALLEXCEPT('Table (3)','Table (3)'[cl1]))

Measure 5 = IF([avg1]>=0,[avg1],IF([avg2]>=0,[avg2],BLANK()))

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , try like

GYM Results= if( [GYM ii] >=0, [GYM ii], if( [GYM] >=0, [GYM], 0 )

[Anonymous]

Amit,

I tried that too its not working.

[az38]

Hi @Anonymous 

try this rewritten sentence

GYM Results = 

VAR GYM = CALCULATE(AVERAGE('JMH'[GYM]))
VAR GYMii = CALCULATE(AVERAGE( 'General'[GYM]))

RETURN 
IF( GYM >= 0, GYM, GYMii)

[Anonymous]

I am getting syntax errors