Get single item with max count per group

[Gusd8]

Greetings, thank you in advance for looking at this.

I am guessing this is easy to do, but I am just having a brain cramp.

I have two tables,
Table 1 ist of reports...so it is Report ID and Report name

Table 2 is a list of Report views...so it is Report ID, User ID and Date

My goal is to have an output that has Report ID, User ID, Total Views

Where I am having difficulty right now is I want each Report ID to be listed once, the User ID to be the User ID that had the most views for that report and then their total views for that report. (I hope that is clear)

The page needs to have a date filter available because they will want to look at the data by week, month and quarter.

I am hoping someone can help me with the creation of this visual. Again, Thank You for looking and any insight you have.

[CoreyP · Accepted solution]

This really comes down to modeling. Here's what I've set up and seems to achieve what I understand your requirement to be.

My Sample Data:

My model:

DAX measures:

View Count = COUNTROWS( ReportViews )

View Rank = IF( ReportViews[View Count] = 0 , BLANK() , RANKX( ALL( 'dim Users'[UserID] ) , ReportViews[View Count] , , DESC , Skip ) )

Output:

To only see the user with the most views, I have a filter on the table visual for the rank: