Forum Discussion
Calculating a Filtered Sum
HI Let's say I have a table like this, table titled PROFIT AND LOSS DETAILS ACCT NAME Line Amount Revenue 20 COGS 12 Fringe ...
Try either:
= CALCULATE(SUM('PROFIT AND LOSS DETAIL'[Line Amount]);[ACCT NAME]='Revenue' ; [ACCT NAME]='Cost of Goods Sold')
Or the more explicit
= CALCULATE(SUM('PROFIT AND LOSS DETAIL'[Line Amount]);filter('PROFIT AND LOSS DETAIL'; [ACCT NAME]='Revenue' ; [ACCT NAME]='Cost of Goods Sold'))
Thanks for your heIp. tried both. It seems like the formatting causes the program to try to read "revenue" and Cost of Goods Sold" as tables, not a column result being used as a filter. It reads error message : could not find table 'revenue'