Forum Discussion
How to have dynamic aggregation in PowerPivot?
Hello I create a pivot in Excel and I put a field in the 'Values' area of the pivot. There I have to choose the type of aggregation, like sum, average etc. Is it possible to choose different ...
amitchandak
Super User
Super UserAnonymous , If the model has been taken from power BI
Best is two measure
Sales sum= calculate(sum(Table[Value]), filter(Table, Table[KPI] = "Sales"))
Stock Avg= calculate(Average(Table[Value]), filter(Table, Table[KPI] = "Stock "))
or
If(Max(Table[KPI])= "Sales", Sum(Table[Value]) , Average(Table[Value]))