Forum Discussion

michaelsparrow's avatar
michaelsparrow
Icon for Helper I rankHelper I
9 years ago

Aggregation while drilling up and down

    I am wondering how to adjust the aggregation of the values in 'Average of Available' while drilling up and down. The first attachment is showing the data variation. The second atta...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

michaelsparrow

 

In Power BI Desktop, you can't achieve like SSAS SCOPE statement to specify different aggregation on different hierarchy level.

 

Regards,

  • michaelsparrow's avatar
    michaelsparrow
    Icon for Helper I rankHelper I
    9 years ago

    Sorry, are you saying it isn't possible to do what I've asked?

     

    cheers