Total count

[samuel_brierley]

Hi can someone lend some hep,

Im looking for an expression that will count how mnay times an address occurs in a set of data,

=count([device address] )

=count(total([device address]))

both give the same number which is a count of how mnay times that address is found in the row which obviosuly is just one

[Gysbert_Wassenaar]

count( total [device address]) will show the total number of addresses that are possible with the current selections.

If you want to ignore selections you need count({1} total [device address])

See this blog post for more information: The Aggregation Scope

[gines_rueda]

Could you try with this ?

=COUNT ( DISTINCT [device address] )

[Sokkorn]

Hi Samuel,

Did you try this yet:

=count(TOTAL [device address]) OR

=count({1} [device address])

Regards,

Sokkorn

[#5]

if you try this

=count([device address] ) //  then this code also count the duplicate value

=count(total([device address]))  // then this code  also count the duplicate value on selection

if you try this

=count( distinct [device address] )    //then this code count only distinct value

=count(distinct total[device address] )    //  then this code count only distinct value on selection