Filter table based on two columns

[A037371]

I have a data set in a table with "planned budget" ,"actual cost" for different projects. For my different visualisations, I would like to filter the table such that it does not show projects where "planned budget" , "actual cost" are both zero. for eg. in the below sample table, I would like the project XML to completely filter out from all the different visualisation / reports.

This seems simple however I am not able to solve this, please help. I am new to Power BI

Project	Project ID	Planned Budget	Actual Cost
ABC	1	100000	500000
XYZ	2	200000	150000
XML	3	0	0
ETC	4	50000	0
RTC	5	0	50000

[Phil_Seamark]

Hi @A037371,

The Visual, Report and Page level filters won't let you accumulate these filters, but you can filter the table in Power Query, or DAX by creating another version of the table that eliminates these rows.

If you never want the rows then perhaps apply this filter in Power Query.  If you sometimes need these rows then generate two versions of the table (1 with and 1 without these rows)

Otherwise, learn some DAX and write your measures to apply this filtering as they run.

[A037371]

@Phil_Seamark- thank you for your reply. I will try to build some formula to "not consider" these rows from the table

[A037371 · Accepted solution]

I figured out one way of doing it. See attached. I created two measures (Total AC & Total PB) to calculate the total of Actual Cost and Planned Budget. Then I created a calculated column for my logic test. The column returns “True” if Actual Cost and Planned Budget are both 0; false if the condition isn’t met.

Logic Test = IF([Total AC]=0 && [Total PB]=0,"True","False")