topic Re: Suprresing zero values in DAX Commands and Tips

Suprresing zero values

Priya2007 — Thu, 12 Nov 2020 07:03:09 GMT

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 .

Re: Suprresing zero values

wdx223_Daniel — Thu, 12 Nov 2020 07:24:22 GMT

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

Re: Suprresing zero values

Priya2007 — Thu, 12 Nov 2020 07:31:30 GMT

Hi Daniel,

I have tried but it is not working

Re: Suprresing zero values

kumar27 — Thu, 12 Nov 2020 07:36:25 GMT

Write is not 0.00

OR
use basic filtering and select all except 0.00

Re: Suprresing zero values

Priya2007 — Thu, 12 Nov 2020 07:38:50 GMT

Hi,

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

Re: Suprresing zero values

kumar27 — Thu, 12 Nov 2020 07:40:45 GMT

write 0.00 in place 0 at advanced filter

Re: Suprresing zero values

Priya2007 — Thu, 12 Nov 2020 07:42:36 GMT

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

Re: Suprresing zero values

wdx223_Daniel — Thu, 12 Nov 2020 08:07:45 GMT

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

Re: Suprresing zero values

Payeras_BI — Wed, 25 Nov 2020 10:51:07 GMT

Hi Priya2007

Try by using the filter pane like this:

Re: Suprresing zero values

Payeras_BI — Wed, 25 Nov 2020 10:56:02 GMT

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,