Calculate same value but in different dates

[Anonymous]

Hello everyone,

Thank you for reading my query. Currently, I'm counting the location of event launching by different date but my DAX is always counted only unique location name instead of diffrent date as you can see the image below. You will notice that there is one location which had event in 2 dates, but my DAX still count only 4 instead of 5

This is my DAX, my table Date also has Start and End Date columns.

And this is my wish outcome: It will count as 5 if the location has diffrent event's date.

I hope you can help me to solve my problem. Thank you again so much.

[amitchandak]

@Anonymous ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

Hello @amitchandak ,

I attached the table below for you to refer. Assume we will count the event type (Column C) is Group Detail (F2F) with HCO (Column B) in different date (Column A). For example, HCO 4 will be count as 4 following by different dates. Thank you.

Date               HCO        Event Type

01/07/2022	HCO 1	Detail (F2F)
02/07/2022	HCO 2	Detail (F2F)
03/07/2022	HCO 3	Detail (F2F)
04/07/2022	HCO 4	Group Detail (F2F)
05/07/2022	HCO 5	Group Detail (F2F)
06/07/2022	HCO 6	Detail (F2F)
07/07/2022	HCO 7	Detail (F2F)
08/07/2022	HCO 8	Detail (F2F)
09/07/2022	HCO 9	Detail (F2F)
10/07/2022	HCO 10	Group Detail (F2F)
11/07/2022	HCO 4	Group Detail (F2F)
12/07/2022	HCO 5	Group Detail (F2F)
13/07/2022	HCO 4	Group Detail (F2F)
14/07/2022	HCO 4	Group Detail (F2F)
15/07/2022	HCO 5	Group Detail (F2F)
16/07/2022	HCO 16	Remote Detail
17/07/2022	HCO 17	Detail (F2F)
18/07/2022	HCO 18	Detail (F2F)
19/07/2022	HCO 19	Detail (F2F)

[amitchandak]

@Anonymous , I think I am still not clear of that

Try like

countx(filter(Table, Table[Event Type] = "Group Detail (F2F)" ) , [Date])

[Anonymous]

Hello @amitchandak , thank you for your reply but it can't help for my solution. As you can see the image  below when I choose one HCO, next column appears 2 dates so it means this location has 2 Group Detail event. And I'm stuck for my DAX since it only count as 1 event (the small box on the left).

For the table I gave you on above. You can see the HCO 4 has 4 Group Detail (F2F) by different dates:

Date               HCO        Event Type

04/07/2022	HCO 4	Group Detail (F2F)
11/07/2022	HCO 4	Group Detail (F2F)
13/07/2022	HCO 4	Group Detail (F2F)
14/07/2022	HCO 4	Group Detail (F2F)