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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Power BI matching check

Hello everyone,

 

I am struggling with something currently.

 

Explanation:

column ds_request_attribute_id 4495 shows the value I need per ds_request_id. Now I would like to see the ds_request_id's with no value. 

Fatih1907_0-1647954982293.png

The columns above are from table ds_request_attribute_value, but table ds_request (this is like the main table, connected to everything) also has the column ds_request_id. When I used LOOKUPVALUE, it gave the following error: 'A table of multiple values was supplied when a single value was expected'. Does anyone have an idea how to fix this? I just want to see the ds_request_id's with no value while using ds_request_attribute_id 4495

 

Help is really appreciated and thanks in advance!

3 REPLIES 3
v-angzheng-msft
Community Support
Community Support

Hi, @Anonymous 

Could you please consider sharing more details about it and posting expected result so it is clear on what needs to be implemented?  And It would be great if there is a sample file without any sesentive information here.

It makes it easier to give you a solution.

  1. Sample (dummy dataset) data as text, use the table tool in the editing bar
  2. Expected output from sample data
  3. Explanation in words of how to get from 1. to 2.

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

 

 

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

parry2k
Super User
Super User

@Anonymous it will be easier if you share a screenshot of the data model, what is value? 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

In this case, value is the expected production and 4495 in column ds_request_attribute_id (table ds_request_attribute_value) shows it. 

I hope it is clear now.

Fatih1907_1-1647957975107.png

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors