Disconnected/Summary Table

[Anonymous]

Hi all,

I wish to create a small summary table that gives my users a bit more information with key metrics on a table. Ideally, I only have one slicer with years 2021,2022 etc.  How can I create a table with a summary of Total sales, Total orders received to date, Completed Orders to date and several key months i.e 2,4,5,6,8,14 that show a Order completion % based on when the orders where complete. For example we are in the 6month (June), some of the orders such as from Camberwell stores have all been delivered but in the 4month only 6 orders were completed.

How can i create such a table as below in PowerBI and connect it to my master table with order and delivery dates?

Stores	Total Sales	Total Orders	Orders Delivered to date	2Month	4Month	5Month	6Month	8Month	14Month
Hampton	12000	100	90	20%	40%	75%	90%
Camberwell	50000	20	20		30%	75%	100%
Caufield	900000	30	5	2%		17%
Sandringham	200000	150	70				47%
Mentone	30000	40	35				88%
Sandtown	170000	500	120				24%

I have created a table (Placed on the rows) Categories = {
("Total Sales","01"),
("Total Orders to date","02"),
("Orders Delivered to date","03"),
("2Month","04"),
("4Month","05"),
("5Month","06"),
("6Month","07"),
("8Month","07"),
("14Month","07")
}

[Dhacd · Accepted solution]

Hi @Anonymous ,

I can provide you with a direction.
Create measures for all the categories you have mentioned. 
Eg: MeasureTotalsales = sum(table[Total Sales])
MeasureTotal Orders to date = Sum(Total Orders) and so on....

And create a switch like below.
Switch('categorytable'[Categories] ,
       "Total Sales",MeasureTotalsales,
        "Total Orders to date",MeasureTotal Orders to date,
                                         .
                                          .

till the last table.
Then use the category column from the category table inside of a table and add the switch measure as another column. Make sure that the category table and the fact table have no relationship.

Reply if you face any issues.

If this post helps, then please consider accepting it as the solution to help the other members find it more quickly.
Regards,
Atma.