Count Only one time occurrence in column

Amit_Jain1 · 02-14-2021 12:40 PM

Hi Everyone,

I am trying to count the Nymbers where Number are not Repeated in ColA

ColA
25
67
25
25
67
54
54
15
25

here
25 is Repeated 4 Time’s
67 is Repeated 2 Time’s
54 is Repeated 2 Time’s
15 is Repeated only once
Also Blank Cell should be Omitted

So Count should be 1

Thanks

Steve

Try:

COUNT(table[ColA] - LIST(""))

See also:

Amit_Jain1

i tried your Formula but it’s showing Count of All Unique Number

what Actually i want to have Count of Numbers which are Appearing only once in column
(Skipping Blank and More then Once)

Steve

Ah, I misunderstood. Sorry.

I’m not aware of a way to get only the unique values.

Koichi_Tsuji

COUNT(UNIQUE(table[ColA] - LIST("")))

Is this?

Amit_Jain1

Same Result It’s also Counting Repeatable Number which are Appearing Again and again

Suvrutt_Gurjar

Please try the following. However, the expressions could be sync time expensive.

Please create a VC called say [SortType] with an expression something like

IF( IN([_THISROW].[ColA], SELECT(Table Name[ColA], [_ROWNUMBER]<>[_THISROW].[_ROWNUMBER])), “Duplicate”,“UniqueValue”)

In another VC called say [UniqueCount] , please have an expression like

COUNT(SELECT(Table Name[SortType], [SortType]=“UniqueValue”))