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])
Are there any code examples left?
New code examples in category Other
-
Other 2023-03-27 22:50:10 how to select the whole line in vscode with keyboard shortcut
-
Other 2022-03-27 22:45:24 income of a web developer
-
Other 2022-03-27 22:35:01 \pyrcc_main.py: File does not exist 'resources.qrc'
-
Other 2022-03-27 22:30:45 rick roll embed code
-
Other 2022-03-27 22:20:08 Circuit_04_Potentiometer
-
Other 2022-03-27 22:20:05 iterative power
-
Other 2022-03-27 22:15:11 flutter run all
-
Other 2022-03-27 22:10:05 when is karlson release
-
Other 2022-03-27 22:10:02 wp .htaccess example
-
Other 2022-03-27 22:00:08 bash pause in file read line by line