Calculate Distinct Count based on value of other column

[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?

[Vvelarde]

@caito103

Hi, are you using a measure ?

You should use a measure not a calculated column

Victor

Lima - Peru

[dtartaglia]

If your trying to count the rows, this should work:

NumClientes = CALCULATE ( COUNTROWS(Hoja2),Hoja2[Clase] = "Factura (v)")

[dtartaglia]

...as a measure

[caito103]

Yes, i did it as a measure:

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

But now i dont know how to use distinct with this, can be good use GroupBy function to group by CodLegal and get only one CodLegal if this have the "Factura (v)"? 

I tried to used it but didnt work:

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

Greetings!

[Vvelarde · Accepted solution]

@caito103

Try with this: 

Measure = CALCULATE(DISTINCTCOUNT(Hoja2[Codlegal]),FILTER(Hoja2,Hoja2[Clase]="Factura (v)"))

or also can try with:

Measure2 = COUNTROWS(CALCULATETABLE(DISTINCT(Hoja2[CodLegal]),FILTER(Hoja2,Hoja2[Clase]="Factura (v)")))

[caito103]

worked! THank you so much!

[dtartaglia]

Hi,

DISTINCTCOUNT counts the values in the column. Can you use COUNTROWS then filter distinct in the visual?

[caito103]

Sorry, but how can i use DISTINCT from the visual filters? I just got filter by value (Factura (v)). 

Thank you so much!