Forum Discussion

A037371's avatar
A037371
New Member
8 years ago
Solved

Filter table based on two columns

  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 wher...
  • A037371's avatar
    A037371
    8 years ago

    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")

     

     

     

     

A037371's avatar
A037371
New Member
8 years ago

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

A037371's avatar
A037371
New Member
8 years ago

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")