Forum Discussion
Summarize Multiple Values from Different Table within either of Table - File Attached
Hi biengineer ,
According to your description, here are my steps you can follow as a solution.
(1) My test data is the same as yours.
(2) We can create a table.
Table = GENERATE ( SUMMARIZE ( 'A', 'A'[Machine Name], 'A'[Operation], 'A'[Time] ), SELECTCOLUMNS ( RELATEDTABLE ( 'B' ), "Item", 'B'[Item], "Mcss", 'B'[Mcss], "Quantity", 'B'[Quantity] ) )(3) Then the result is as follows.
Please refer to the following document for more information.
Summarizing values from different tables - Microsoft Power BI Community
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi biengineer ,
According to your description, here are my steps you can follow as a solution.
(1) My test data is the same as yours.
(2) We can create a table.
Table =
GENERATE (
SUMMARIZE ( 'A', 'A'[Machine Name], 'A'[Operation], 'A'[Time] ),
SELECTCOLUMNS (
RELATEDTABLE ( 'B' ),
"Item", 'B'[Item],
"Mcss", 'B'[Mcss],
"Quantity", 'B'[Quantity]
)
)
(3) Then the result is as follows.
Please refer to the following document for more information.
Summarizing values from different tables - Microsoft Power BI Community
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
In your answer, is it possible to insert excluding filters?
I mean, using your answer as an example, is it possible to exclude when the column "item" from related "b" is different than null, or "J", etc...
Example:
Table =
GENERATE (
SUMMARIZE ( 'A', 'A'[Machine Name], 'A'[Operation], 'A'[Time] ),
SELECTCOLUMNS (
RELATEDTABLE ( 'B' ),
"Item", IF('B'[Item] <> NULL),
"Mcss", 'B'[Mcss],
"Quantity",'B'[Quantity]
)
)