How to calculate the percent of contribution to the total (Percent to total)

[Kira_Net]

Hi there,
I wanted to create a matrix visualization which has a client field on the Row, Ship A, Ship B, Ship C and Ship D on the Values. My problem is my table looks as follows. I need to create a percent to total for all shipping methods to put them as individual fields on the values section. Can somebody help me please?

Client	Shipping Method	Packed Date
ABC	Ship A	03/22/2021
XYZ	Ship D	04/22/2021
ABC	Ship A	03/27/2021
XYZ	Ship C	07/12/2021
XYZ	Ship B	05/23/2021
ABC	Ship C	01/19/2022

[amitchandak]

@Kira_Net , A measure like

divide(count(Table[Shipping Method]) , calculate(count(Table[Shipping Method]) , allselected()) )

or

divide(count(Table[Shipping Method]) , calculate(count(Table[Shipping Method]) , all()) )

[Kira_Net]

@amitchandak Thank you. But this only gives me the percent to total for all shipping method. But I need how many percent of product XYZ shipped by Ship A, Ship B, Ship C and Ship D?

[v-xiaotang · Accepted solution]

Hi @Kira_Net 

"But I need how many percent of product XYZ shipped by Ship A, Ship B, Ship C and Ship D" 

in this scenario, you can try this 

Percentage = 
var _countPermethod= CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'), 'Table'[Client]=MIN('Table'[Client]) && 'Table'[Shipping Method]=MIN('Table'[Shipping Method])))
var _countTotalmethod= CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[Client]=MIN('Table'[Client])))
return 
DIVIDE (
    _countPermethod,
    _countTotalmethod
)

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.