Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
In Power BI Desktop, you can't achieve like SSAS SCOPE statement to specify different aggregation on different hierarchy level.
Regards,
Sorry, are you saying it isn't possible to do what I've asked?
cheers
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |