Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
(data provided is an example based on the real-life structure of my data)
Each row is a food choice, associated with a person's name and their gender. There is a variable number of choices for each person.
As in real life, everyone likes Pizza.
The main graph shows the number of choice of each food type.
I would like to count the number of people who chose ALL of the most popular (x) number of options.
So in the example case:
Number of names who chose Pizza: 11
Number who chose Pizza + Cake: 7
Number who chose Pizza + Cake + Eggs: 2
Number who chose Pizza + Cake + Eggs + Pasta: 1
Number who chose Pizza + Cake + Eggs + Pasta + Fish: 0
I would like this to be re-calculated based on the most-popular results in a filtered set. For example, I would like to be able to look at new results just for Males or Females, or excluding Cake.
I can think of a way to do this in Excel by manually listing the top foods for a given combination of filters, but I would like to have something dynamic.
Is this possible?
Solved! Go to Solution.
I have tested it on my local environment, the sample steps below are for you reference.
Result.
Regards,
Charlie Liao
I have tested it on my local environment, the sample steps below are for you reference.
Result.
Regards,
Charlie Liao
Thank you for your help. As far as I can tell this does the trick on a static set of data, although it can't compute new variations as simply as applying a new filter.
Despite this, it will still prove useful.
Thank you for your assistance.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |