Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
mariogonzra
New Member

Counting rows taking into account different columns

Hi, everyone:

 

So I'm working with a table that looks basically like this:

ReportNamePageNameUserIDDate
AA14/7
AB14/7
AC14/7
AA15/7
AB15/7
AA24/7
AC24/7
BA14/7
BB15/7

 

What I need is a measure that returns a count for each time a user checks a report on a different day. So. for example, for ReportName = A; User 1 visited 4/ and 5/7 (2 days); whereas User 2 visited 4/7 only. I would expect the outcome of measure to be 3.

On the other hand, for ReportName = B, I would expect 2.

 

What's the cleanest way to accomplish these? I've been trying with CALCULATE + SUMMARIZECOLUMNS, but cannot seem to figure it out.

 

Thanks a lot,

 

Mario

1 ACCEPTED SOLUTION
DataInsights
Super User
Super User

@mariogonzra,

 

Try this measure. Since ReportName in the visual provides filter context, it's optional to include ReportName in the SUMMARIZE expression.

 

Count Measure = 
COUNTROWS ( SUMMARIZE ( 'Table', 'Table'[UserID], 'Table'[Date] ) )

 

DataInsights_0-1720637398847.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
DataInsights
Super User
Super User

@mariogonzra,

 

Try this measure. Since ReportName in the visual provides filter context, it's optional to include ReportName in the SUMMARIZE expression.

 

Count Measure = 
COUNTROWS ( SUMMARIZE ( 'Table', 'Table'[UserID], 'Table'[Date] ) )

 

DataInsights_0-1720637398847.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors