Column Chart including Total

[mahra-in]

Hi

I need help in makin g column chart including total

I have a Table 1:

Name	Type	Delivery
A	External	On Time
B	External	On Time
C	Internal	Late
D	External	On Time
E	Internal	Late
F	Internal	Late
G	External	Late
H	External	Late
I	External	On Time
J	Internal	On Time
K	Internal	Late
L	Internal	Late

From the above Table 1, the on time delivery & their percentage on Total rows is

Type	On Time	%
External	4	33%
Internal	1	8%
Total	5	42%

And the column chart as attached photo is what I need

Thanks in advance

[Ashish_Mathur]

Hi,

Try these measures:

On Time = CALCULATE(COUNTROWS(Data),Data[Delivery]="On time")

On Time (%) = [On Time]/CALCULATE(COUNTROWS(Data),ALL(Data))

Hope this help.

[ricardocamargos]

Hi @mahra-in,

Try this new table:

TBL =
VAR tbl_1 = SUMMARIZE(
Table1;
Table1[Type];
"Ontime";
CALCULATE(COUNT(Table1[Delivery]); FILTER(Table1; Table1[Delivery] = "On Time"));
"%";
CALCULATE(COUNT(Table1[Delivery]); FILTER(Table1; Table1[Delivery] = "On Time")) / CALCULATE(COUNT(Table1[Delivery]); ALL(Table1))
)
VAR tb_row = ROW("Type"; {"Total"} ; "OnTime"; SUMX(tbl_1; [Ontime]); "%"; SUMX(tbl_1; [%]))
VAR tb = UNION(tbl_1; tb_row)

RETURN tb

Ricardo