Forum Discussion
Counting rows taking into account different columns
Hi, everyone:
So I'm working with a table that looks basically like this:
| ReportName | PageName | UserID | Date |
| A | A | 1 | 4/7 |
| A | B | 1 | 4/7 |
| A | C | 1 | 4/7 |
| A | A | 1 | 5/7 |
| A | B | 1 | 5/7 |
| A | A | 2 | 4/7 |
| A | C | 2 | 4/7 |
| B | A | 1 | 4/7 |
| B | B | 1 | 5/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
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] ) )
1 Reply
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] ) )