Counting Unique Values

Hi,

I have a column with a project number and project part name. I would like to return another column with only the unique project parts and the number. The filters on the page/column must remain active.

I did get something through this formula based on a filter on the name, but I want the formula to look for all unique lines, without entering a "hard" text.

CALCULATE(COUNTROWS(d_projectpart), FILTER(d_projectpart, d_projectpart[Projectpart]="IWAS II"))

The table should look something like this after the formula.

It should also be possible to add other columns with sum values

Thanks in advance for the help!