Aggregation while drilling up and down

[michaelsparrow]

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

[v-sihou-msft]

@michaelsparrow

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

Regards,

[michaelsparrow]

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

cheers

[v-sihou-msft]

@michaelsparrow

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