Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
I am a bit of a novice in Power BI and am appealing for help. I work for an organisation that has people who operate from a base location, and turn out to events, ie, each base location has their own exclusive membership, which can opt to turn out to an event. The data is collected by member number and event number in relation to each base location.
1. I am trying to work out how to calculate by base location, the total number of events each member has attended.
2. I then want to display the data by an 80/20, rule but on a sliding scale for each location. This is because I would like to show how many people are doing 80 percent of the work for that base location, but then be able to identify the point at which 50 percent of people are doing 50 percent of the work for that base location.
I am asking for both formulas together (numbers 1 and 2 above), as the way the first is done, may impact the ability to do the second (I hope that makes sense).
A sample of the data looks as below:
Base Location | Member | Event | Attended | Event Date |
Bally | 1354 | 2615 | Y | 1/01/2019 |
Bally | 4672 | 2615 | Y | 1/01/2019 |
Mont Bleu | 5151 | 2617 | Y | 5/01/2019 |
Mont Bleu | 4130 | 2617 | Y | 5/01/2019 |
Mont Bleu | 2090 | 2617 | Y | 5/01/2019 |
Bally | 1354 | 2618 | Y | 1/01/2019 |
Bally | 4672 | 2618 | Y | 1/01/2019 |
Bally | 6135 | 2618 | Y | 1/01/2019 |
Bally | 1354 | 2620 | Y | 1/01/2019 |
Avon | 7113 | 2616 | Y | 5/01/2019 |
Avon | 7114 | 2616 | Y | 5/01/2019 |
Mont Bleu | 2090 | 2619 | Y | 3/01/2019 |
Mont Bleu | 4001 | 2619 | Y | 3/01/2019 |
Mont Bleu | 5151 | 2619 | Y | 3/01/2019 |
Mont Bleu | 4130 | 2619 | Y | 3/01/2019 |
Mont Bleu | 2227 | 2619 | Y | 3/01/2019 |
Bally | 4672 | 2620 | Y | 4/01/2019 |
Bally | 6135 | 2620 | Y | 4/01/2019 |
Bally | 1354 | 2620 | Y | 4/01/2019 |
Avon | 7114 | 2621 | Y | 2/01/2019 |
Avon | 7113 | 2622 | Y | 3/01/2019 |
Avon | 9876 | 2621 | Y | 2/01/2019 |
Mont Bleu | 4130 | 2623 | Y | 4/01/2019 |
Mont Bleu | 2227 | 2623 | Y | 4/01/2019 |
Mont Bleu | 4001 | 2623 | Y | 4/01/2019 |
Any assistance would be gratefully received. Thanks in advance.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |