I want to determine how specific occurrences are distributed compared to the average and show it in a graph. I have 2 columns Column A ID and B interactions. Each interaction is associated with only 1 id however 1 id may be associated with multiple interactions. In powerpivot, I used the following formula to obtain the average count(B)/distinctcount(A). This gave me the average number of interactions per ID. Now I want to determine the distribution of all interactions compared to the average, but I want to see them grouped together so if the average is 5, I want to know the total number of ID's per number of interactions and compare them to the average.
Thanks
Thanks