Count based on days

[bouyazbekj]

Hello everyone,

I'm trying to count the number of days on a job for a specific client. In the following table for example the number of days is 6 total. Each day has multiple tickets . Any idea of how to acheive this? I'm happy with a "card" for visualization. 

Year	Month	Day	TicketNumber	BusinessPartnerName
2019	August	1	38775	Encana Corporation
2019	August	1	38776	Encana Corporation
2019	August	1	39547	Encana Corporation
2019	August	1	39548	Encana Corporation
2019	August	2	38797	Encana Corporation
2019	August	2	38798	Encana Corporation
2019	August	2	39574	Encana Corporation
2019	August	2	39575	Encana Corporation
2019	August	3	38829	Encana Corporation
2019	August	3	38830	Encana Corporation
2019	August	3	39600	Encana Corporation
2019	August	3	39601	Encana Corporation
2019	August	4	38875	Encana Corporation
2019	August	4	38876	Encana Corporation
2019	August	4	39630	Encana Corporation
2019	August	4	39631	Encana Corporation
2019	August	5	38903	Encana Corporation
2019	August	5	38929	Encana Corporation
2019	August	5	39667	Encana Corporation
2019	August	5	39668	Encana Corporation
2019	August	6	39681	Encana Corporation
2019	August	6	39703	Encana Corporation
2019	August	6	39704	Encana Corporation
2019	August	6	39713	Encana Corporation
2019	August	6	39714	Encana Corporation

[pethali84]

Hi, I believe this can be achieved by using maximum days. 

[Anonymous · Accepted solution]

HI @bouyazbekj 

You can try the following measure:

_Count_M =
VAR _TEMP =
    GROUPBY ( T27, T27[Day], T27[Month], T27[Year] )
VAR _COUNT =    
     COUNTROWS ( _TEMP )
RETURN
    _COUNT

[bouyazbekj]

Hello @Anonymous  

Thanks a lot!!!