cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
michaelsparrow Regular Visitor
Regular Visitor

Aggregation while drilling up and down

 

Capture.PNG

 

Capture.PNG

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 attachment is showing that there are a lot of data points the same but for different dates.

The hierarchy goes Resource->Base->Date.

Example: ANFA-NSN

 - Date level: straight-forward, it is 29 at each date, which shows on the graph.

- Base Level: I want the average of the 'available people' so I want it to show 29. Fine so far.

- Resource Level: I want all of the 'bases' to SUM together for each resource. Problem at this level.

 

How do I get the 'Average of Available' to get AVERAGE at one level and SUM at another level?

 

Thanks

3 REPLIES 3
Moderator v-sihou-msft
Moderator

Re: Aggregation while drilling up and down

@michaelsparrow

 

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

 

Regards,

michaelsparrow Regular Visitor
Regular Visitor

Re: Aggregation while drilling up and down

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

 

cheers

Moderator v-sihou-msft
Moderator

Re: Aggregation while drilling up and down

@michaelsparrow

 

No, it's not possible in Power BI Desktop.