Filter on multiple measures for specific context

[jmg80525]

Greetings.  I have a financial report that has an undeseriable output based on row context.  For whatever reason accounting will post a expense transaction and then reverse so the total amount will be zero.   It shows up in the report as shown below (Total Actual) since there are data values. I can't just filter out Total Actual <> 0 since there are times where there are budget transactions, but no expenses.  I can't filter out Total Variance <> 0 since sometimes total budget magically equals total  expenses.  I need a measurement where it would filter out rows produced under a context where Total Budget = 0 and Total Actual  = 0.  I'm having issues producing a compund measurement that I could apply to the matrix visual to capture and filter out this scenario.

[jmg80525]

Just what I needed to get me focused.  Above suggestion works perfect.

[amitchandak · Accepted solution]

@jmg80525 , No very clear.

You can have measure like

if(calculate([Total Budget], all('Date'))  =0, blank(), [Total Budget])

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.