Merge and do summation of values

[dshah12]

I have a table which have Values similar 

Applno	applid	Masterappid	role	Amount
1	102	null	Master	200
2	103	103	phase	100
3	102	102	phase	50

Expected Output : I want the phases file to be merged into master files and the total amount. I check if ids match than it should sum all phases into master with respect to role 

Thank you 

Help Appreciated

Applno	applid	Masterappid	role	Amount
1	102	null	Master	350

[Anonymous · Accepted solution]

Hi @dshah12 ,

Please try the following methods and check if they can solve your problem:

1.Create the two simple table.

2.Create the new measure to calculate total.

To Amount = SUM('Table'[Amount])

3.Select the role field in the Filters pane. Edit the show items is 1.

4.Drag the measure into the table visual. The result is shown below.

Best Regards,

Wisdom Wu

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