Combining Measures for Group Chart

[johnmurphy]

Dear All,

I was hoping you could help me out, I have the following data set

Customer                Contract Type        Potential Sales Amt        Annual Fee          Services

1                                Lease                        1050                               5000                  10

2                                Own                          500                                1000                  150

3                                New                        20000                                   0                    0

4                                Lease                        800                                 3000                    70

5                                Own                          1000                               1000                 150

6                                New                        15000                                   0                    0

And I want to create a graph as the following

Stacked Chart

1.Potential ---> Total Potential Sales with Segmentation by Contract Type

2. Services ---> Total Services all up

3. Annual Fees+Lease ---> Total Annual Fees + Potential Sales Amt (only for Lease)

Thanks.

John

[v-xjiin-msft · Accepted solution]

@johnmurphy

To achieve your requirement, you can refer to following measures:

1. Potential ---> Total Potential Sales with Segmentation by Contract Type

Total Potential Sales = CALCULATE(SUM(Table1[Potential Sales Amt]),FILTER(ALL(Table1),Table1[Contract Type]=MAX(Table1[Contract Type])))

2.Services ---> Total Services all up

Total Services = SUMX(ALL(Table1),Table1[Services])

3. Annual Fees+Lease ---> Total Annual Fees + Potential Sales Amt (only for Lease)

Total Annual Fees = CALCULATE(SUM(Table1[Annual Fee]),FILTER(ALL(Table1),Table1[Contract Type]="Lease"))

Thanks,
Xi Jin.