Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Mystery
Helper I
Helper I

Need help in DAX function

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
1 ACCEPTED SOLUTION
AlB
Community Champion
Community Champion

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.  

 

 

 

View solution in original post

2 REPLIES 2
AlB
Community Champion
Community Champion

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.  

 

 

 

Thanks let me check that out.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!