Matrix with filters and slicers - get a % of total by customer

[lnorman]

I have a Matrix with Customer Name, Customer Number, Order Type, order count per type with a subtotal by customer.

Date Slicer and Customer Number Slicer - Filtering on a specific group or order statuses

How do I write a new measure to get the % by order type for each customer (500/557, 15/557, .2/557, 40/557)  "Show value as" will calucate based on the whole column, not each individual customer.  

Customer Name	Customer Number	Order Type	Distinct Order Count	How do I get: % by order type
Customer1	12345	Copied	500	90%
		Freight	15	3%
		Quote	2	0%
		Scanner	40	7%
	Total		557	100%
Customer2	12246	Copied	25	18%
		Freight	1	1%
		Manual	50	35%
		Quote	20	14%
		Scanner	45	32%
			141	100%

Have been reearching solutions for a while and trying various measures but can't quite get the result I need.

Thanks.

[lnorman]

I found my own solution without having to create new measures.  Instead of my order type being in a ROW, I moved it to Column.  This then allowed me to to have Value Count of Order and Value Show as % of Row.

[Anonymous]

Check out this forum entry: https://community.powerbi.com/t5/Desktop/Unable-to-Get-Correct-Percentage-when-Filter-or-Slicer-Used...

They accomplished what you are trying to do.