Showing results for 
Search instead for 
Did you mean: 
New Member

Problem to concatenate groups in different contexts

Hello, guys, I'm trying to concatenate an information in order to find my hole productive order. 

When I start my prodution I have a comum number the "Prodution Order". In all of my productive orders I have the components and the main products. The components are tagget with the subgroup "RE" and the main products with the subgroup "PR0". 
I have many differents main products with the same components and I'm trying to find all Prodution Order with all components and main products and only sum the quantite of their components but when I try to use the "SUM" and "SUMX" expression the power b.i don't reconize that and show all components independently if in this Prodution Order contains an specific "PR0".




In this picture shows that my PR0 group "GB" have used "EM" group but "EM" is used in all PR0 groups like "GB","NB","DT" and "SV". So can you help me to solve that? 


Helpful resources


Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.