Count doesn't add up to the real total

[ZakariAK]

Hi!

Im trying to make different distinctcounts with measures based on the same column and its 3 values, im trying to count the rows by an ID column, and made a count for each one of the values and also one for blank rows. The thing is, when adding up all these counts it doesnt coincide with the total count, here i give you de different measures:

Real Total = DISTINCTCOUNT('CRM'[Id Cliente])

En Seguimiento =

CALCULATE(

    DISTINCTCOUNT(CRM[Id Cliente]),

    CRM[Resultado] = "Seguimiento")

 ______

Ilocalizado =

CALCULATE(

    DISTINCTCOUNT(CRM[Id Cliente]),

    CRM[Resultado] = "Ilocalizado"

)

 _________

Cerrado =

CALCULATE(

    DISTINCTCOUNT(CRM[Id Cliente]),

    CRM[Resultado] = "Cierre"

)

 _________

Blanco =

CALCULATE(

    DISTINCTCOUNT(CRM[Id Cliente]),

    ISBLANK(CRM[Resultado])

)

when adding upp the four measures, the total is +10 than the total count, anybody has a clue of why this is happening?

Thanks in advance

[FreemanZ]

hi @ZakariAK ,

distinct coiunt not adding up correctly is normal, supposing you have a table like:

Region	Product
East	A
East	B
West	A

distinct count of product for east region is 2 (A and B);

distinct count of product for west region is 1 (A);

they add up to 3, 

BUT, if we distinct count the product directly, we only get 2 (A and B).

Is that so?

[ZakariAK]

What would be a correct way of counting the values without counting ID duplicates then?

This is a sample of the data: 

 

[FreemanZ]

hi @ZakariAK ,

first of all, that is not advisible. if you insist, with data table in my previous post,  try like:

measure = 
SUMX(
    VALUES(data[region]),
    CALCULATE(DISTINCTCOUNT(data[product]))
)

it worked like:

[ZakariAK]

Hi FreemanZ,

Could you please extrapolate it to the sample I gave you? Thanks in advance

[FreemanZ]

try like:

measure = 

SUMX(

    VALUES(data[result]),

 CALCULATE(DISTINCTCOUNT(data[id client]))

)