Piechart based on a different total than aggregated sum

[Anonymous]

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

[v-frfei-msft · Accepted solution]

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))

If it doesn't meet your requirement. Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

Regards,

Frank

[v-frfei-msft]

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