Forum Discussion
Aggregating calculated measure with slider
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:
- Use a slicer to select a date range to analyzef
- aggregate the total funding received for each person in that date range
- 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!
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.
2 Replies
- Jihwan_Kim
Super User
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.
- AnonymousNot applicable
Thank you so much! That completely solved it. I really, really appreciate the help!