Create sum and average slicer

[Anonymous]

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) 

[ReneMoawad · Accepted solution]

Hi,

I believe you already created the table Aggregation including 2 rows (Sum and Avg)

Now you need to create a new Measure like the below:

Aggregation Measure =

Var selectedAgg = SELECTEDVALUE(AggregationTable[Aggregation]) 
Return

IF(

    selectedAgg = "Sum"

    , SUM(Table[Amount])

    , AVERAGE(Table[Amount])

)

[amitchandak]

@Anonymous , Not very clear, You can create a sum or avg measure and then can create a field parameter or calculation group

https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0