Forum Discussion
Calculate Daily Active User
Refer to my blog on same lines. Check for current employee
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.
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.
Thank you very much for resolution. both of the answers work and I tested both and found Greg's solution has better performance.