Forum Discussion
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
- amitchandakSuper User
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. - jmg80525Helper II
Just what I needed to get me focused. Above suggestion works perfect.