Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Omit Measure on Table

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 :])

 

 

 

 

  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous ,

    Try like

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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous ,

    Try like

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

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    4 years ago

    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.