The way I've got round this is by creating a master dimension with an if statement.
IF(AGGR(<my expression>, my dimension), my dimension, null())
Then I put this in as my dimension and include the measure expression. I can then uncheck the show null values from my dimension and the null values will have beenremoved.
Hello Mr. Andy Weir
I have tried to apply your solution to my problem with the following logic
=IF(AGGR((Sum([Amount LocCur])-Sum([Paid LocCur])='0'),Customer), Customer, null())
where Amount LocCur is - Invoices amount in Local Currency
Paid Loc CUr is - Amount paid in local currency.
I am trying to eliminate all Customers and Invoices in which the Amount Due ( Amount Local Currency - Amount Paid)=0..
Thanks for your time