Changing percentage based off slicer selection

Question

Hello I am trying to calculate the overall average makeup when using slicers. For example, I have two visuals, one displaying the overall average, and one displaying the sectors that make up that overall average percent. The trouble I run into is when looking at multple sections of the same sector on visual two. I want that visual to be taking the average of the two sections combined and not the sum. So depending on which values I selected through the slicers there may be more than 2 or 3 sections of the same section. in which case the some would need to be divided by the distinct count of sections. All data is being pulled from the same table.

anonymous · Answer

Hi&nbsp;japeq029&nbsp;
&nbsp;
How does your original table look like? AVERAGE is working if you table is like this

&nbsp;

japeq029 · Answer

Hi Vera,The original table looks something like this. For the visual, I am using a bar chart with the category as the Axis, the Score Group as the legend, and the values variable is what I am trying to calculate.&nbsp;&nbsp;&nbsp;