Forum Discussion

Priya2007's avatar
Priya2007
Frequent Visitor
5 years ago

Suprresing zero values

Hi , I am using below measures to get the result : WIP = SUMX(SUMMARIZE(Transactions, Transactions[PROJECT_NO], Transactions[FISCAL_PERIOD]),[WIP Amount])   WIP Amount = CALCULATE(sum(Transact...
Payeras_BI's avatar
Payeras_BI
Icon for Solution Sage rankSolution Sage
5 years ago

Hi Priya2007 

 

Try by using the filter pane like this:

 

 

 

 

  • Payeras_BI's avatar
    Payeras_BI
    Icon for Solution Sage rankSolution Sage
    5 years ago

    Hi Priya2007 ,

     

    I editted my previous answer because it was lacking a "-" in front of the 0.01 in the "is less than" part of the filter.  Sorry for the typo.

     

    The way to get rid of the zeros (floating point issue) using the filter pane would be like this:

     

     

    Regards,