Forum Discussion
Filter table based on two columns
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")
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.
Phil_Seamark- thank you for your reply. I will try to build some formula to "not consider" these rows from the table
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")