chart for frequency of certain calculations

[SarahAlsterspre]

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

[Jihwan_Kim · Accepted 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.

[SarahAlsterspre]

thank you very much, this works 🙂