Suprresing zero values

[Priya2007]

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 .

[Payeras_BI]

Hi @Priya2007 

Try by using the filter pane like this:

[Payeras_BI]

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,

[kumar27]

Write is not 0.00

OR
use basic filtering and select all except 0.00

[Priya2007]

Hi,

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

[kumar27]

write 0.00 in place 0 at advanced filter

[Priya2007]

Hi , I have tried that , but thats not working .

[wdx223_Daniel]

@Priya2007 add a IF out of your code,like

WIP=VAR _Total= SUMX(SUMMARIZE(Transactions, Transactions[PROJECT_NO], Transactions[FISCAL_PERIOD]),[WIP Amount]) RETURN IF(_Total<>0,_Total)

if this still not work, it might be some very small value, like 0.000000001, which come from the floating-point calculation

[wdx223_Daniel]

@Priya2007 try to delete the "+0" at the end of the WIP measure.

[Priya2007]

Hi Daniel,

I have tried but it is not working