Calculate Distinct Count based in other column value

[caito103]

Hello,

Im trying to count each client of the company if the cell have in the "Clase" column the data "Factura (v)". But, in "Codlegal" column i have multples times each code, so i need to use distinct to no repeat each one.

Im trying with:

NumClientes = CALCULATE ( DISTINCTCOUNT(Hoja2[Codlegal]);Hoja2[Clase] = "Factura (v)")

But i get "30,23K" and are only 2.916. I tried with differents formulas but i cant get it, any advice?

[v-sihou-msft]

@caito103

Your measure supposes to work. Make sure your slice it with client field.

Regards,

[cs_skit · Accepted solution]

solution should be

COUNTROWS(FILTER(ALL(Table);Table[column]="Factura (v)"))

if you don't want the independent context like if you want it to change when you slice remove the ALL