Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

 

 

Need Help
Tips and Tricks
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    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

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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's avatar
      v-frfei-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      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