Forum Discussion
Solved
Calculate error
Hi all, I am trying to use Calculate with a measure as a filter and got the below error: "A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. ...
The filter expression i.e [Lost Referrers] = 1 must be used to filter an appropriate table first.
Total Rev New Referrer = CALCULATE ( [Total Revenue], FILTER ( TableName, [Lost Referrers] = 1 ) )
Depending on your case, you can use
1) TableName
2)ALL(TableName)
3)ALL(TableName[ColumnName])etc
The filter expression i.e [Lost Referrers] = 1 must be used to filter an appropriate table first.
Total Rev New Referrer = CALCULATE ( [Total Revenue], FILTER ( TableName, [Lost Referrers] = 1 ) )
Depending on your case, you can use
1) TableName
2)ALL(TableName)
3)ALL(TableName[ColumnName])
etc
