Counting Unique Values

[Anonymous]

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.

Projectnumber	Project part name	Total
10011001	Station 1	3
20022002	Station 2	5
30033003	Station 3	6
40044004	Station 4	1

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

Thanks in advance for the help!

[Anonymous · Accepted solution]

Hi,

I have found the solution via filters. So there was no formula necessary.

Thanks for the help!

[Icey]

Hi @Anonymous ,

---

The table should look something like this after the formula.

Projectnumber	Project part name	Total
10011001	Station 1	3
20022002	Station 2	5
30033003	Station 3	6
40044004	Station 4	1

---

How about the original table before the formula? I need to compare the original table with the result table.

Best Regards,

Icey