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 ...
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'
Odd.
When you're entering the DAX does the autocomplete help at all?
I did notice your first formula example tries filter[ACCT NAME]='Revenue' which won't work as filter requires a table name not column, but my two example should have correct syntax.