Calculate Daily Active User

[Anonymous]

Hi,

I want to display a trend line of active users every day based on start and end dates. I am able to get to this displayed but I am struggled with adding a slicer to filter the company users are in.

here is the sample data

Company	Name	Start	End
ABC	Liam	6/1/2019	3/1/2020
ABC	Noah	7/1/2019	2/1/2020
ABC	William	8/1/2019	1/1/2020
DEF	James	9/1/2019	3/1/2020
DEF	Oliver	10/1/2019	2/1/2020
DEF	Benjamin	11/1/2019	1/1/2020
GHI	Elijah	12/1/2019	3/1/2020
GHI	Lucas	1/1/2020	2/1/2020
GHI	Mason	2/1/2020	2/1/2020
GHI	Logan	3/1/2020	3/1/2020

I created a date table and a calculated column using: 

Active = CALCULATE(DISTINCTCOUNT(DATA[Name]),FILTER(DATA,DATA[Start]<='Date'[Date] && DATA[End]>='Date'[Date]))

However, I want to add a slicer to filter the company so that the trend line only displays the active users in the selected company.

Can someone help?

[amitchandak · Accepted solution]

Refer to my blog on same lines. Check for current employee

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[Greg_Deckler · Accepted solution]

I read this through a couple times and now I understand it. You can't use a column for this because columns are not dynamic. Columns are calculated at the time of data load and thus cannot be dynamic via user interaction like selecting a company. What you want is the Open Tickets measure I created here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364

Since it is a measure, it can be dynamic based upon user interaction.

[Anonymous]

Thank you very much for resolution. both of the answers work and I tested both and found Greg's solution has better performance.

[amitchandak · Accepted solution]

Refer to my blog on same lines. Check for current employee

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...