HELP! Conditional filtering with sum in a REF. Or maybe it's something else! XD

[MaurySj]

Hello! First of all, this is translated with google translate. I hope you are well and that you understand.
Second. Thanks so much for reading.

I'm stuck with an expression that I can't put together.

The app is for project management and control, with its requirements and the necessary products and services to complete it.

I have many more tables, but I will only name the ones that intervene.

A table "DEPLOYMENT" that contains all the necessary things for each "REQUIREMENT" of all the "PROJECTS".
In this table ("DEPLOYMENT"), many times, products or services with different quantities are repeated.

Create some sample data:

What I want to do and I can't do is:
Obtain a filtered list, where each product or service only appears once, with its added quantities.

Lick to the spreadsheet with the same data as the images.

Thank you very much in advance for any help you can give me.

[TeeSee1 · Accepted solution]

The easiest way if you are not picky with your display format, then, you can create two virtual columns that concatenate (PROJECT & SERVICE) and (PROJECT & PRODUCT).

You can then configure your views to group on these VC's with GROUP AGGREGATE on [Quantity].

If you want a tabular format, then you need to create tables to extract unique combinations of  (PROJECT & SERVICE) and (PROJECT & PRODUCT). Then create VCs with SUM(SELECT(here get [Quantity] with Filtered by  (PROJECT & SERVICE) )).

Maybe other community experts can propose better solutions..

[TeeSee1 · Accepted solution]

You can write an action, add a new row to another table using values from this row.

In the "Only if the condition is true", set something like

ISBLANK(
 FILTER("report table",
  AND([project] = [_THISROW].[project], [service] = [_THISROW].[service])
 )
)

 to show the action icon only for the rows whose entries have not been mande in the report table ensuring uniqueness.

I would show the action icon as inline so the entries in the report table can be made quickly.