Forum Discussion

Mactoff's avatar
Mactoff
Regular Visitor
3 years ago
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 ...
DAX
DistinctCountX
powerbi
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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.

     

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

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.

 

 

 

  • Mactoff's avatar
    Mactoff
    Regular Visitor
    3 years ago

    I am reviewing now. I was unable to make it work on my first pass but that doesn't mean it doesn't work. Appreciate you putting this together. I'll get back to you later this afternoon.

  • Mactoff's avatar
    Mactoff
    Regular Visitor
    3 years ago

    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.

  • Mactoff's avatar
    Mactoff
    Regular Visitor
    3 years ago

    Yea I'm not sure. I generated the extra rows and I still just get "blank" in my card. The measure works fine when I make a table visual and implement User as a row.

  • Mactoff's avatar
    Mactoff
    Regular Visitor
    3 years ago

    Sorry for all the comments lol, I figured it out. It's because my Quarter filter is using the dimTable Quarter, not the 'Report views' table Quarter I just needed to create a relationship between the two tables. Thanks again!