SelectAll from Slicer should give average value

[NithinBN]

Hello All,

I have 3 table like this,

and relation bwtween them like this, 

 I have made slicer out of "Region" table which has selectAll,

 I need sum of all people in one graph (this is working), in second i need average of Sales % (currently its summing up).

How I can achive average sales ? Both charts need to controlled by same slicer.

Thanks!

[Anonymous · Accepted solution]

HI @NithinBN,

>>In the sales graph (bottom left) I should get Average sales, now I am getting sum

You can right-click on the value fields that you used on chat to change the summarize mode from 'sum' to 'average'.

Work with aggregates (sum, average, and so on) in the Power BI service 

Regards,

Xiaoxin Sheng

[Greg_Deckler]

@NithinBN Not sure I am following exactly. In the second graph over in the Visualizations pane, click the drop down arrow of the column in the Values area and change aggregation to Average instead of Sum?

[NithinBN]

@Greg_Deckler : In the sales graph (bottom left) I should get Average sales, now I am getting sum