Filtering

[dmutka]

I have a table that shows all transactions for each customer, such as Invoice, Credit Memo, and Payennt. I am trying to build a report that shows only customers that have open balances on Credit Memos AND open balances on Invoices. I am having trouble figuring out how to do this, as I created a matrix with all the customers and the column headers as the transaction type, and the Open Amount as the values. If there is a simple solution that I am missing let me know. Otherwise, I would appreciate any advice, tips, tricks etc.

[Greg_Deckler · Accepted solution]

Sounds like a measure with a FILTER where SUM([Credit Memos]) > 0 && SUM([Invoices])>0 but tough to say without sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490