urgent help needed with histogram or count of activity days -- please review explanation

[Anonymous]

I want to create a visual/measure that calculates the total number of days in a given month (in this example, it would be FEBRUARY 2020) a person was active (activity completed = true). 

I have this Activity table:

UserID	ActivityID	Activity completed	Date Assigned	Date Completed
1	44	True	2/1/2020	3/1/2020
2	60	True	2/1/2020	2/10/2020
3	60	False	2/1/2020
1	2533	False	2/1/2020
2	345	True	2/1/2020	2/20/2020
3	435	True	2/1/2020	2/2/2020
1	366	False	2/1/2020
2	345	True	2/1/2020	2/20/2020
3	354	True	2/1/2020	2/25/2020

I want the output to be a graph that has the number of days active on the x axis and then the y axis is the count of users. 

In chart form it owuld be:

Days active	Count of users
1
2	2
3
4
5
6
7
etc. to 30

The reason it is 2 in 2 days active is because userID 2 completed 2 items on the same day (3 line items, only 2 unique days)  and it doesn't count user ID because that person completed the action item in march not february and i'm tracking for february

@Greg_Deckler you've been incredibly helpful to me this week, let me know if you have any ideas! Thank you so much!

[v-xuding-msft]

Hi @Anonymous ,

You could reference the patterns:Dynamic Segmentation to have a try.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-xuding-msft I need help writing the actual measure though - might you be able to assist me with that?