Aggregating count of counts filter by date

DrH — Wed, 08 Feb 2023 07:55:42 GMT

Need help aggregating and filtering the underlying data by date.

Peter, James and John perform actions (they read books and/or papers) on dates January 1 to January 9.

Date	Action	Person
jan 1	Book	Peter
jan 2	Paper	James
jan 2	Book	John
jan 4	Book	Peter
jan 4	Book	Peter
jan 5	Paper	James
jan 6	Book	James
jan 7	Paper	John
jan 8	Book	Peter
jan 9	Paper	Peter

I want to aggregate this data by Action to show how many times a certain action was performed by somebody during a given date interval. And I must be able to filter dates. If we take the data over all dates we get:

	1	2	>=3
Book	2		1
Paper	2	1

This shows that in the full time interval 2 persons read a book ONE time (James and John), and 1 person read a book AT LEAST THREE times (Peter, he did it 4 times).

Also, 2 persons read a paper ONE time and 1 person read a paper TWICE.

If we take January 2-6 we get this:

	1	2	>=3
Book	2	1
Paper		1

Here we see that again 2 persons read ONE book and 1 person read TWO.

And 1 person read the paper TWICE.

So, I need to aggregate like this, filter by date and show number of events like 1, 2, and >=3.

Ideas?

Re: Aggregating count of counts filter by date

amitchandak — Wed, 08 Feb 2023 02:13:59 GMT

DrH , I think you need Dynamic Segmentation Bucketing Binning on count measure, refer example

https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

Re: Aggregating count of counts filter by date

DrH — Wed, 08 Feb 2023 07:46:16 GMT

Thanks for the attempt, but nope, that is not what I am looking for.

topic Re: Aggregating count of counts filter by date in DAX Commands and Tips

Aggregating count of counts filter by date

Re: Aggregating count of counts filter by date

Re: Aggregating count of counts filter by date