cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pjverweij
Helper II
Helper II

DAX unique count clients in period

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])))
1 ACCEPTED SOLUTION
camargos88
Community Champion
Community Champion

Hi @pjverweij ,

 

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])))


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

1 REPLY 1
camargos88
Community Champion
Community Champion

Hi @pjverweij ,

 

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])))


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!