Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 ...
powerpivot
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

 

 

Expected result: =
SWITCH (
    SELECTEDVALUE ( Data[KPI] ),
    "Sales", SUM ( Data[Value] ),
    "Stock", AVERAGE ( Data[Value] ),
    BLANK ()
)