cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Anonymous
Not applicable

## Piechart based on a different total than aggregated sum

Here is the situation

I have a Total Accessible Market for an entire Market Segment (lets call it \$1M - SUM(Demand[TAM]), which is in one table (Market).  In a different table I have the top three customers in that market and their sales for the year (Cust1/Sales=\$100K;Cust2/Sales= \$200K; and Cust3 Sales = \$300K - Customer[Name] and SUM(Customer[Sales]).

I want to create a Piechart which the total is the \$1M (SUM(Demand[TAM]), not the SUM(Customer[Sales]) for each of the customers.  Basically ending up with a Dynamic 'Other' Group (if you will).

I tried a couple of things, but nothing works.

Any ideas or hints?

Thanks,

Jay

1 ACCEPTED SOLUTION
Community Support

Hi @Anonymous ,

One sample for your reference. We can create multi measures to work on it.

`a = CALCULATE(SUM(Table1[values]),FILTER(Table1,Table1[name]="a"))`
`B = CALCULATE(SUM(Table1[values]),FILTER(Table1,Table1[name]="b"))`
`C = CALCULATE(SUM(Table1[values]),FILTER(Table1,Table1[name]="c"))`
`Others = 1000- CALCULATE(SUM(Table1[values]),ALL(Table1))`

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
2 REPLIES 2
Community Support

Hi @Anonymous ,

One sample for your reference. We can create multi measures to work on it.

`a = CALCULATE(SUM(Table1[values]),FILTER(Table1,Table1[name]="a"))`
`B = CALCULATE(SUM(Table1[values]),FILTER(Table1,Table1[name]="b"))`
`C = CALCULATE(SUM(Table1[values]),FILTER(Table1,Table1[name]="c"))`
`Others = 1000- CALCULATE(SUM(Table1[values]),ALL(Table1))`

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Community Support

Hi @Anonymous ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors