power bi A function 'LOOKUPVALUE' has been used in a True/False expression that is used as a table filter expression. This is not allowed. code example

Example: power bi A function 'LOOKUPVALUE' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

The following comparisons are not supported:

1. Comparing to a column to a measure: SalesHeader[TerritoryID] = [LargestTerritory]
2. Comparing a column to a an aggregate value: SalesHeader[TerritoryID] = MAX(TerritoryID[TerritoryID]])
3. Comparing a column to a What-If parameter: SalesHeader[TerritoryID] = TerritoryParameter[TerritoryParameter Value]

In fact, you only have three options if you want to filter a column in a CALCULATE/CALCULATETABLE function:

1. Compare the column to a static value: 
   SalesHeader[TerritoryID] = 6

2. Use variables to create a static value:
   VAR LargestTerritory = MAX(SalesHeader[TerritoryID])

3. Use a FILTER function instead of a true/false expression:
   FILTER(SalesHeader, SalesHeader[TerritoryID] = [LargestTerritory])