How to show percentage of total

[PaulusB]

I have a table containing sold shoes by customer. How do I visualize the sold shoes per sex as a percentage of the total order?

So the nominator = total order quantity per sex

and the denominator = total order quantity

Orderno	Itemnr	OrderQuantity	Clientno	Sex
100	A	4	10359	Girl
101	B	5	10160	Girl
101	C	6	10160	Boy
101	D	1	10160	Boy
102	A	2	10175	Girl

[PaulusB]

Many thanks!

[Jihwan_Kim · Accepted solution]

Expected result: =
VAR orderspersex =
CALCULATE ( SUM ( Data[OrderQuantity] ), ALLEXCEPT ( Data, Data[Sex] ) )
VAR ordersall =
CALCULATE ( SUM ( Data[OrderQuantity] ), REMOVEFILTERS () )
RETURN
DIVIDE ( orderspersex, ordersall )

[amitchandak]

@PaulusB , these measures can help

divide(sum(Table[OrderQuantity]), calculate(sum(Table[OrderQuantity]), allselected()))

divide(sumX(filter(Table, table[Sex] ="Girl"), Table[OrderQuantity]), calculate(sum(Table[OrderQuantity]), allselected()))

divide(sumX(filter(Table, table[Sex] ="Boy"), Table[OrderQuantity]), calculate(sum(Table[OrderQuantity]), allselected()))