cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## 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 9
Super User

Try by using the filter pane like this:

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain
Super User

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,

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain

Write is not 0.00

OR
use basic filtering and select all except 0.00

Frequent Visitor

Hi,

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

write 0.00 in place 0 at advanced filter

Frequent Visitor

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

Super User

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

Super User

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

Frequent Visitor

Hi Daniel,

I have tried but it is not working

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors