Forum Discussion

jmg80525's avatar
jmg80525
Icon for Helper II rankHelper 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 b...
context
measure
  • amitchandak's avatar
    amitchandak
    4 years ago

    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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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.