Aggregating calculated measure with slider

[Anonymous]

Hi all,

I have a fairly straightforward problem that I am struggling to do in power BI.  have a bunch of data on people who received funding on different dates. It looks something like this:

Person	Date	Money
A	1/1/2019	400
B	1/1/2018	50
A	5/1/2018	600
B	4/1/2019	85
A	1/1/2020	100
A	8/1/2018	40

I would like to:

1. Use a slicer to select a date range to analyzef
2. aggregate the total funding received for each person in that date range
3. bin the totals to figure out, for that date range, how many individuals received different sums of money.

More specifically, if I chose a date range of 1/1/2019 - 1/1/2020 for the above data, I get the following sums:

Person	Money
A	500
B	85

Then, I'd want to aggregate to create a table similar to:

Funding Range	# people
0-249	1
250-499	1
500-1000	0

It seems like the easiest thing to do might be to create a dynamic new table based off of the slider range that summed the funds given for each person. Then, I could use that to build the aggregated table from part (3). However, I cannot figure out how to do so.

I'm somewhat new to Power BI, so any help you can offer would be much appreciated. For reference, I've created a .pbix file with dummy data here: https://drive.google.com/file/d/1zDwKzkU-SdkLxQymkCQcgKcjJg2oEaSB/view?usp=sharing

Thanks!

[Anonymous]

Thank you so much! That completely solved it. I really, really appreciate the help!

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.

-All measures are in the sample pbix file, and all steps are numbered in front of each measure.

-I suggest having a data model like below.

https://www.dropbox.com/s/6k1dlgz0pag4wyx/test%20dashboard.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/