Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey,
I have data with users having participated in something. Some users participated once, some twice, some a 100 times. What I would like to show in a chart is the frequency of each "participation sum" e.g. how many users participated once, how many twice and so on. And I would like to have a chart with y axis = sum of participations, x axis = frequency (1,2,3,4,5,...max.)
I have the measure count(users.[users]) but I dont know how to put it into a graph with the sum of participations.
I am really looking forward to your help!
Sarah
Solved! Go to Solution.
Hi,
I tried to create a sample pbix file like below.
Please check the below picture and the attahced pbix file.
I hope the below can provide some ideas on how to create a solution for your datamodel.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I tried to create a sample pbix file like below.
Please check the below picture and the attahced pbix file.
I hope the below can provide some ideas on how to create a solution for your datamodel.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
thank you very much, this works 🙂
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |