Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How to filter across multiple colmuns

I have a budget table and I would like ti filter out any rows that have $0 Annual Budget AND $0 YTD Budget AND $0 YTD Actual.  Is this possible?  I am still fairly new to Power BI, so forgive my simp...
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi Anonymous 

    Please create a measure with a combination of three value
    Total = sum(Annual budget column) + sum(YTD budget) + sum(YTD actual)

    Use the measure in the Visual level filter and set a value greater than 0


    Let me know if that works for you


    If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Anonymous 

Please create a measure with a combination of three value
Total = sum(Annual budget column) + sum(YTD budget) + sum(YTD actual)

Use the measure in the Visual level filter and set a value greater than 0


Let me know if that works for you


If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

thank you, that was an easy solution.