User Acitivities dax help

[ROG]

Hi guys,

I have created a report to show the users activities, which is not the Audit logs as I don't access.

On the table below, I have the users name, and the number os activities they have done.

I would like to create a dax to show me the numbers of users that have the userAcitvity_type = ViewReport AND AnalyzedByExecl, on the past 3 months. Can you help me, please?

Many thanks!

[Anonymous]

Hi @ROG ,

Your calculation is based on data model. Please share a sample file with me and show me a screenshot with the result you want. This will make it easier for me to find the solution.

Best Regards,
Rico Zhou

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