Omit Measure on Table

[Anonymous]

I have the following calculated table on the % remaining column.  How do I omit values that show 100% or omit 0/0? My formula is basic as it is 

% Remaining: = 1- ('GL298A'[Total:] / 'Yearly Budget'[2022 Budget :])

[V-lianl-msft]

Hi ,

Please try 

= VAR C_ = DIVIDE('GL298A'[Total:] , 'Yearly Budget'[2022 Budget :])
IF(C_>0&&C_<1,1-C_,BLANK())

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous ,

Try like

% Remaining: = if( 'Yearly Budget'[2022 Budget :] <> 0 &&'GL298A'[Total:]  <> 0,  1- divide('GL298A'[Total:] , 'Yearly Budget'[2022 Budget :], blank() ) , blank())