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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Prima_
Helper II
Helper II

How to retrieve a value from a table by passing a measure value

Hi, 

 

I find 'Most used product' ([Sub_Product Name]) using a measure from the values in Product Table.
I need to find out if the stock is available ([AvailableOrNot]) for this Sub_Prodcut from another table 'Stock'.

 

Here's the scenario:

Product Table has
[Product Name], [Sub_Product Name]
A A1
A A2
A A3
B B1
...

Stock Table has

[Product Name] [Sub_Product Name] [AvailableOrNot]
A A1 Not Available
A A2 Available
A A3
B  B1

...

Let's say, the Most used product is A2 ----> This is displayed in a Card Visual.
I want to show AvailableOrNot in another Card Visual.
How to write a measure to retrieve 'Stock'[AvailableOrNot] field from Stock Table where 'Stock'[Sub_Product Name] = [Most used product]

 

Thank you.

1 ACCEPTED SOLUTION
Prima_
Helper II
Helper II

I used 

Prima__0-1680681570751.png

It worked. Will test somemore. Thanks

 

View solution in original post

1 REPLY 1
Prima_
Helper II
Helper II

I used 

Prima__0-1680681570751.png

It worked. Will test somemore. Thanks

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.