Forum Discussion

JBBoucly's avatar
JBBoucly
Regular Visitor
3 years ago

Data picking from others tables

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,

Need Help
Tutorial Requests

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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