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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Debo1996
Regular Visitor

Use conditional logic based on a list of values filtered from a column in a related table...

Hi, 

 

So I have two tables voucher table (contains a list of all vouchers with voucher number as the primary key) and item table (contains a list of items in each voucher, so multiple enteries for same voucher possible).

 

Debo1996_0-1669308365838.png  

 

Debo1996_1-1669308400015.png

 

Now I need a DAX formula which can help me fill the column Does this voucher contain banana? (return "banana" if yes or else "no"). 

I am struggling with returing a list of item names that correspond to a particular voucher and then perform an operation on it.

 

Thanks!

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Debo1996 ,

A new column in the voucher

 

flag =

var _cnt = countx(filter(item, item[Voucher number] = Voucher[Voucher number] &&[Item] = "Banana"),item [Item])

return

if(isblank(_cnt), "No", "Banana")

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Debo1996 ,

A new column in the voucher

 

flag =

var _cnt = countx(filter(item, item[Voucher number] = Voucher[Voucher number] &&[Item] = "Banana"),item [Item])

return

if(isblank(_cnt), "No", "Banana")

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.