Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Weight of values by two subset level

Hi All,

 

I am having some issues when calculation the total aggregate value by two subsets:

SalesSubset1Subset 2Total Partial aggregationExpected
4324Location1Brand 1718916,01%
67567Location1Brand 17189193,99%
9899Location1Brand 21668859,32%
6789Location1Brand 21668840,68%
5423Location2Brand 21044215,19%
98998Location2Brand 210442194,81%
8987Location2Brand 18574310,48%
76756Location2Brand 18574389,52%
4545Location3Brand 2455499,80%
9Location3Brand 245540,20%
8796Location3Brand 11723151,05%
8435Location3Brand 11723148,95%
67567Location4Brand 115755642,88%
89989Location4Brand 115755657,12%
659678Location4Brand 269421295,03%
34534Location4Brand 26942124,97%

 

By using calculate(sum[sales]; ...) I don't find a way to aggregate patialy (Col:Total Partial aggregation)

 

Has anyone a way to calculate those partial aggregations, that later on meke possible to make aggregation  at two levels.

 

Thanks in advance!

JC

1 REPLY 1
BIAB
Resolver I
Resolver I

Can you provide a sample PBIX file.  I would say that if you create a measure to divide your Total Partical Agregation from your Sales you should get the Expected result.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors