Breaking News: Grepper is joining You.com. Read the official announcement!

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.

Powerful Penguin answered on February 24, 2021 Popularity 1/10 Helpfulness 1/10

answer 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.

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.

Comment

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

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: www.sqlgene.com

Tags: expression filter function this whatever

Link to this answer
Share Copy Link

Contributed on Feb 24 2021

Powerful Penguin

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

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.

Contents

More Related Answers

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.

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.