Counting rows taking into account different columns

mariogonzra — Wed, 10 Jul 2024 15:08:51 GMT

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

Re: Counting rows taking into account different columns

DataInsights — Wed, 10 Jul 2024 18:50:54 GMT

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] ) )

topic Re: Counting rows taking into account different columns in DAX Commands and Tips

Counting rows taking into account different columns

Re: Counting rows taking into account different columns