Forum Discussion
Solved
Reoccurring Distinct Counts
Hello, I have a table that logs user activity across my dashboard that looks like this: My stakeholder has requested to get a count of distinct users who have viewed the report in this ...
Hi,
Please check the below picture and the attached pbix file.
I tried to create it based on what I have checked in the question above.
Hi,
Please check the below picture and the attached pbix file.
I tried to create it based on what I have checked in the question above.
Yea I believe this isn't working for me because my source table doesn't actually have a recorded row for a Quarter in which they did not view the report, it only has records for when they did view the report. So essentially my sample table above would only have the rows where ViewedReport = 1. I think if I can generate rows for Quarters they did not view this solution should work.