Create sum and average slicer

Question

Hi everyone, i would like to create a slicer including 2 options sum and average like this so that when i need to see the group by of my data by sum or average. For example in a week the data is 7 with the view sum but with the view average the data will be 1 (7/7 days)&nbsp;

renemoawad · Accepted Answer

Hi,&nbsp;I believe you already created the table Aggregation including 2 rows (Sum and Avg)&nbsp;Now you need to create a new Measure like the below:&nbsp;Aggregation Measure =Var selectedAgg = SELECTEDVALUE(AggregationTable[Aggregation])&nbsp;ReturnIF(&nbsp; &nbsp; selectedAgg = "Sum"&nbsp; &nbsp; , SUM(Table[Amount])&nbsp; &nbsp; , AVERAGE(Table[Amount]))

Forum Discussion

Create sum and average slicer

2 Replies

Related content

Creating date slicer removes data

Creating an average

Creating a dynamic slicer

Trouble Creating Average of Daily Averages - While Keeping it Filterable

Average and Moving Average