Forum Discussion
Isolate users missing an activity during a filtered time frame
Hi,
Based on the data that you have shared, show the expected result very clearly..
Thank you for looking into my problem. I do not have a specific format to return the result. I am open to ideas here. We want to find users who have missed a certain activities for a selected time frame. So, if user "A" has sent emails but did not send a blog post on October 2022, when selected that date range and deselect activity type "blog post" we should not see user A. But, currently I am being unable to do so (see image). Here, I have selected all but emails but I am still showing the customer because he has sent emails in that time frame. The expected result should not even return him. I hope this makes sense, please let me know otherwise. Thanks so much!
Hi,
For the selected time period, do you want the table to show those rows which correspond to users:
- who did not engage in the selected activities; or
- who engaged in the selected activities
Please clarify. Share the download link of the PBI file.
Thank you so much for replying. Yes, it's the first scenario where we want to return those rows which correspond to users who did not engage in the selected activities for a selected time frame. You will see how it's not currently working in my pbix file. Thank you again!
Here is the pbix file attached along with the sample data. Please let me know if you have any other question. Regards!