Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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
A1/1/2019400
B1/1/2018    50
A5/1/2018600
B4/1/201985
A1/1/2020100
A8/1/201840


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
B85

 

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

 

Funding Range# people
0-2491
250-4991
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!

2 Replies

  • 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/

  • Anonymous's avatar
    Anonymous
    Not applicable

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