Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Priya2007
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 .Capture.PNG
9 REPLIES 9
Payeras_BI
Super User
Super User

Hi @Priya2007 

 

Try by using the filter pane like this:

 

Payeras_BI_0-1606301407308.png

 

 

 

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

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:

 

Payeras_BI_1-1606301654396.png

 

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
kumar27
Advocate V
Advocate V

Write is not 0.00

OR
use basic filtering and select all except 0.00

Hi,

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

write 0.00 in place 0 at advanced filter

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

@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
Super User
Super User

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

wdx223_Daniel_0-1605165847372.png

 

Hi Daniel,

I have tried but it is not working

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.