Adding a single column at end of Matrix

[PBI5851]

Hello,

 On a matrix table, i am trying to add a calculation at the end, but that measure keeps getting added after every single column. Please advise on how to add that calculated value only once. 

Date	Shipped	Cancelled	Completed
1/1/20	50	30	100
1/5//20	10	20	40
1/7/20	50	60	20
1/9/20	10	10	5

I wish to get the below. 

Date	Shipped	Cancelled	Completed	Complete %
1/1/20	50	30	100	55%
1/5/20	10	20	40	57%
1/7/20	50	60	20	15%
1/9/20	10	10	5	20%

The Shipped, Cancelled and complete are statuses from a single column. Now when i try to add a new measure (completed%), it shows up after every single column.  Any advise please ?

[PBI5851]

sample data... 

Date	AcctID	Status
1/5/2020	A1001	Shipped
1/5/2020	A1002	Shipped
1/5/2020	A1003	Shipped
1/5/2020	A1004	Completed
1/5/2020	A1005	Shipped
1/5/2020	A1006	Shipped
1/6/2020	A1007	Cancelled
1/6/2020	A1008	Completed
1/6/2020	A1009	Shipped
1/6/2020	A1010	Shipped
1/6/2020	A1011	Shipped
1/6/2020	A1012	Cancelled
1/6/2020	A1013	Shipped
1/6/2020	A1014	Cancelled
1/6/2020	A1015	Shipped
1/6/2020	A1016	Cancelled
1/10/2020	A1017	Shipped
1/10/2020	A1018	Completed
1/10/2020	A1019	Cancelled
1/10/2020	A1020	Completed
1/10/2020	A1021	Cancelled
1/10/2020	A1022	Cancelled
1/10/2020	A1023	Cancelled

The measure i have for the matrix is StatusCount = calculate(counta(Accounttable), userelationship (datetable(date), Accounttable(date))). 

[vanessafvg]

the only way to prevent that from happening is to create a measure for each status rather than slice by the status.

see attached.

[amitchandak]

@PBI5851 ,

Create a measure like

divide(sum(Table[Completed]), sumx(Table,Table[Shipped]+Table[Cancelled]+Table[Completed]))

or column like

divide((Table[Completed]), (Table[Shipped]+Table[Cancelled]+Table[Completed]))

[vanessafvg]

how are you creating your measure, can you provide some dummy data?