Further filtering on Simple Waterfall visual

[maddypena07]

Hello all!

I hope that you can point me on the right direction, as I tried to solve this for several days now.

The business case is related to the amount of pieces that can be produced by a group of machines. and how the pieces are lost due to out of program schedules or other reasons.

I've created several calculations that account for these conditions and work well and provide the figures that I need. So far I have this for Capacity pcs (i'm gonna focus on one of the measures, as the other ones are similar):

and in the visual is presented like this

But there are machines that are considered to be offline and need to be filtered out because it impacts the total capacity time:

(only the ones with 0 need to be considered)

but when I add the filter to the waterfall visual, it doesn't work:

I've tried to add another condition directly on my measures, but that doesn't seem to work either. Can you help me to know what i'm doing wrong or why the filter is not working?

Thank you in advance!

Edit to add link to files:

https://drive.google.com/drive/folders/1lI7TL-U0YjeZc1xHlNAOyu1_H2vSSh3z?usp=sharing

As the data is not the same as image references, my question is how can I filter the machines with 0 for nullGrossMachine measure on the "simple waterfall" visual like on the table.

Thanks!

[maddypena07 · Accepted solution]

Excellent community, thank you all for your support.

[Ritaf1983]

Hi @maddypena07 
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[maddypena07]

Hello! 

I edited the post to include a link to a google drive, I was unable to attach .pibx and csv files

Thank you!

[maddypena07]

Hello! I tried to attach files but a message appear telling me that csv and pbix files are not supported.

I hope these are accesible here:

https://drive.google.com/drive/folders/1lI7TL-U0YjeZc1xHlNAOyu1_H2vSSh3z?usp=sharing 

Thanks in advance