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(Transactions[ACTUAL_AMOUNT]),

Filter(Transactions,
SELECTEDVALUE('Transactions'[FISCAL_PERIOD])<=SELECTEDVALUE('Date'[Financial Period Number])),
Filter (Transactions,Transactions[Activity Code Num] >= 3000 && Transactions[Activity Code Num] <= 3999) ,
filter (Transactions,[Expense Code Num] >= 200)

) + 0
 
But I want ro supress the row when WIP is 0 .
I am putting a visual level filter but thats not working .

9 Replies

    • Priya2007's avatar
      Priya2007
      Frequent Visitor
      5 years ago

      Hi Daniel,

      I have tried but it is not working

  • kumar27's avatar
    kumar27
    Advocate V
    5 years ago

    Write is not 0.00

    OR
    use basic filtering and select all except 0.00

    • Priya2007's avatar
      Priya2007
      Frequent Visitor
      5 years ago

      Hi,

      It is a measure, I cant find basic filtering in that .

      • kumar27's avatar
        kumar27
        Advocate V
        5 years ago

        write 0.00 in place 0 at advanced filter

    • Payeras_BI's avatar
      Payeras_BI
      Solution 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,