DAX unique count clients in period

[Anonymous]

Hello everyone,

I have a question about counting unique clients in periods.

I already have his dax command that counts active dossiers. But sometimes a client has more than 1 dossier in a period.

What i want to know is the unique clients per period.

Is there a way to get the unique count of clients through this measure?

If more data is required please let me know.

Any help will be appriciated.

Measure =

SUMX('Dates';

CALCULATE (

COUNTROWS ( Dossiers );

FILTER (

Dossiers;

'Dates'[DD_UITK_TILL] >= Dossiers[Begindate]

&& 'Dates'[DD_UITK_FROM] <= Dossiers[Enddate])))

[camargos88 · Accepted solution]

Hi @Anonymous ,

You can use like:

Measure =

SUMX('Dates';

CALCULATE (

DISTINCTCOUNT(TABLE[CLIENTE_ID]); // or some unique identification for it

FILTER (

Dossiers;

'Dates'[DD_UITK_TILL] >= Dossiers[Begindate]

&& 'Dates'[DD_UITK_FROM] <= Dossiers[Enddate])))

[camargos88 · Accepted solution]

Measure =

SUMX('Dates';

CALCULATE (

DISTINCTCOUNT(TABLE[CLIENTE_ID]); // or some unique identification for it

FILTER (

Dossiers;

'Dates'[DD_UITK_TILL] >= Dossiers[Begindate]

&& 'Dates'[DD_UITK_FROM] <= Dossiers[Enddate])))