All Other Products in Pie Chart

[rampsaladi]

Hi All,

I have requirements where I need to create a Pie Chart with a certain set of products and All other products as one group. The Products and sales information are in the same table and I also have another Product called ALl products along with the Sales. as shown below

Product	$ Amt
All Products	120
Product 1	3
Product 2	5
Product 3	7
Product 4	9
Product 5	30
Product 6	10
Product 7	30

I need to get All Other Products by Subtractinig from ALl products sum of Products 1to 7 and then include this as part of the Pie chart as shown below. Any Help on this would be appreciated

. 

[Zubair_Muhammad]

HI @rampsaladi

How about a new calculated table which you can use in the pie chart...From the modelling tab>>>New Table

Table =
UNION (
    FILTER (
        SUMMARIZE ( TableName, TableName[Product], "$ Amt", SUM ( TableName[$ Amt] ) ),
        [Product] <> "All Products"
    ),
    ROW (
        "Product", "All other Products",
        "$ Amt", CALCULATE ( SUM ( TableName[$ Amt] ), TableName[Product] = "All Products" )
            - CALCULATE ( SUM ( TableName[$ Amt] ), TableName[Product] <> "All Products" )
    )
)

[rampsaladi]

@Zubair_Muhammad Thanks for the reply

I have thought of it but it gets more complicated as the data I showed will be associated to a specific market and time period. I would need to be able to do this for different markets and time periods. If that can be achieved that would be great and you can provide me details on how to 

[Zubair_Muhammad · Accepted solution]

Hi @rampsaladi

May be you can use the Query Editor to add a row for "ALL other products"

- You can pivot the Products Column>> all your products would be in columns

-Then add a column "All other products" subtracting Products 1 to 7 from ALL products

-Now unpivot the products to bring data to orginal form