Solved: Count Unique Value In WW4 - Page 2

desmond_lee · 02-14-2024 07:07 PM

Hi Guys

I just don't know how to get the expression correctly. How do I count unique value in week 4 ? I create this expression but don't know where is my mistake. It call 20 instead of the correct answer 14.

COUNT(SELECT(NC DOC[PROCESS/PROJECT OWNERSHIP],AND(TRUE,TRUE,[_THISROW].[WW]=[WW])))

desmond_lee

Suvrutt

Thnak you again for responding to me. I put a count because the result is a number and TRUE,TURE is do remove duplicate. I try your expression there is an error but I put a count to count the list the answe is correct i.e. 14 See row 5 work week 4

View solution in original post

Suvrutt_Gurjar

Yes, sorry there was a typo in my suggestion. UNIQUE() will produce a list of no duplicate items. You then need to use COUNT() on the list of UNIQUE() items.

I have corrected it in the original post also to avoid any confusion by future readers of the post thread.

I believe you can simply try

COUNT(UNIQUE(SELECT(NC DOC[PROCESS/PROJECT OWNERSHIP],[_THISROW].[WW]=[WW])))

View solution in original post