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])