Data picking from others tables

[JBBoucly]

Hello, I need help in Power BI, here is my problem :

I have a table which for each line give me 2 or 3 results :

In the table1, I want to pick up two information from the table 2 :

• Capacity if Formula = 1 or Processperqty if Formula = 0
  and
• NbOuvrier

The expected result in the table 1 is :

How can I do that ?

Don't know if it's gonna help but here is the model. In red, the tables from where I make the visual 1 and in blue, the tables from where I want to pick up th information :

Thank you,

[Anonymous]

Hi  @JBBoucly ,

What does your Dax formula look like.

Or consider using the Summarize() function to create a calculated table to hold the obtained values and retrieve them in the application in Dax:

SUMMARIZE function (DAX) - DAX | Microsoft Learn

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Liu Yang

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