cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## 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. This is not allowed."

my formula is : Total Rev New Referrer = CALCULATE([Total Revenue],[Lost Referrers]=1)

where Total Revenue is a measure = Sum (sales[revene]) and Lost Referrer is another measure

Lost Referrers = IF([Total Revenue]<>0 && [Total Rev L3M]=0,1,0)

How can I sum the revenues filtering the lost referrer measure = to 1?

1 ACCEPTED SOLUTION
Community Champion

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

Regards
Zubair

2 REPLIES 2
Community Champion

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

Regards
Zubair

Helper I