Need help in DAX function

[Mystery]

Hi,

I am evaluating the below DAX expression

Column 2 = contains(bi_salesFact,bi_salesFact[ProductID],"785",bi_salesFact[Revenue],68.1975)

I get a true where I have a combination as mentioned above.

But for table rows where the ProductID and Revenue values are different there also true is displayed.

Is this the expected behaviour.

Regards

[AlB · Accepted solution]

Hi @Mystery

The code you show will yield the same result in every row and it will be TRUE if the table contains that combination anywhere, in any of the rows. Check the syntax for CONTAINS

What do you need? A calculated column that tells you whether that row has the combination (ProductID, Revenue) you show? If so, you can use this for your column:

Column 2 = bi_salesFact[ProductID]="785" &&  bi_salesFact[Revenue]=68.1975

or this if you were to modify your code to make it work:

Column 2 = contains(CALCULATETABLE(bi_salesFact) ,bi_salesFact[ProductID],"785",bi_salesFact[Revenue],68.1975)

The first version is simpler and more efficient.The second is just for illustrative purposes, but not recommended.  

[Mystery]

Thanks let me check that out.