topic Re: Counting Unique Values in DAX Commands and Tips

Counting Unique Values

Anonymous — Wed, 16 Mar 2022 15:55:50 GMT

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!

Re: Counting Unique Values

Icey — Tue, 22 Mar 2022 01:28:16 GMT

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

Re: Counting Unique Values

Anonymous — Wed, 23 Mar 2022 13:06:09 GMT

Hi,

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

Thanks for the help!