Forum Discussion
Solved
Problem with GROUP BY / SUMMARIZE functions
Hello everyone, I have two tables : 1 with my inventories (inventories = STOCKS[Stock à utilisation libre]) associate with a date and another table with my prices (PRIX). I would like to calcula...
Hi Sthrn ,
You could create a relationship in the Power BI Desktop.
Then create the following measure.
inventories value = SUM('PRIX'[Prix standard])*SUM(STOCKS[Stock à utilisation libre])Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You have a couple of options
- "merge" the tables in Power Query. That's called denormalizing
- let the data model do the work for you - in Power BI link the tables by a common field, and indicated the filter flow from dimension to fact
- use disconnected tables and use LOOKUPVALUE or TREATAS to find the matches
The second option is nearly always preferable. Let the data model do the work.