Forum Discussion
Solved
Lookup Value with 2 matched criteria
Hi guys, I am newbie in power BI, finding the way to use DAX and I have two table as pictures below Product Table Campaign Table Question is: in the first table, I would lik...
Bifinity_75 Thank a lot for your help.
But this code only matches the Brand, doesnt matches the Gender.
For example, for article 10, it shows adidas_kids (which is not correct), it should be adidas_female.
However, I try to learn your logic and code, I change it to:
Result1 =maxx(filter('Campaign Table' , search('Product Table'[Brands] & "_" &'Product Table'[Gender], 'Campaign Table'[Campaign],,0)>0),'Campaign Table'[Brand] & "_" & 'Campaign Table'[Gender])The result is:Thank you so much!
Bifinity_75
Solution Sage
Solution SageHi KieuVuong , create this calculate column:
Result=
maxx(filter('Campaign Table' , search('Campaign Table'[Brand],'Product Table'[Brands],,0)>0),'Campaign Table'[Brand] & "_" & 'Campaign Table'[Gender])
- The result:
Best Regards
Bifinity_75 Thank a lot for your help.
But this code only matches the Brand, doesnt matches the Gender.
For example, for article 10, it shows adidas_kids (which is not correct), it should be adidas_female.
However, I try to learn your logic and code, I change it to:
Result1 =
maxx(filter('Campaign Table' , search('Product Table'[Brands] & "_" &'Product Table'[Gender], 'Campaign Table'[Campaign],,0)>0),'Campaign Table'[Brand] & "_" & 'Campaign Table'[Gender])
The result is:
Thank you so much!