Hi, I am trying to create a power pivot measure that sums with two filters and have tried a variety of ways and it will not work for some reason. There is something simple or obvious that I am missing and guidance would be appreciated.
Example attempts below
This code works
However with the addition of a second filter it no longer works.
Also tried this way
Example attempts below
This code works
Excel Formula:
CALCULATE(SUM('09 FY22_23'[Item Outstanding Amount]),'09 FY22_23'[Category]="Action")
Excel Formula:
=CALCULATE(SUM('09 FY22_23'[Item Outstanding Amount]),'09 FY22_23'[Category]="Action",'09 FY22_23'[Report Month]="Current Month")
Excel Formula:
=CALCULATE(SUM('09 FY22_23'[Item Outstanding Amount]),FILTER('09 FY22_23','09 FY22_23'[Report Month]="Current Month"),'09 FY22_23'[Category]="Action")