Forum Discussion

jmg80525's avatar
jmg80525
Helper II
4 years ago
Solved

Filter on multiple measures for specific context

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 , 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.

2 Replies

  • 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.

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