Measure to sum a group of values in a column

[xeniaay]

Hi, I'm new to the Power BI Community and have problem in setting up a measure to combine the values to be used as the denominator in calculating % in the table below.  I need to sum "PO-FMS" and "PO-PDS" in Docu_Type column to a new group called "PO".  Could anyone show me how to do such measure?  Thank you!

Client	Docu_Type	Inv Amt	Status
ABC	PO-FMS	$100	Transferred
ABC	PO-PDS	$200	Ready
A235	Contract	$300	InFlow
B388	Other	$400	Transferred
02345D	WO	$550	Cancelled
ABC	PO-FMS	$660	Cancelled
DEF	PO-PDS	$770	Cancelled
etggg	Contract	$880	InFlow
23425	Other	$990	Ready
223333	WO	$1,000	Transferred
DEF	PO-FMS	$1,100	InFlow
ABC	PO-PDS	$1,200	Ready

[LivioLanzo · Accepted solution]

@xeniaay

create a dimension like the below and relate it to the main table and then drop NewType to the rows of the matrix

Inv Amt	New Type
PO-FMS	PO
PO-PDS	PO
Contract	Contract
Other	Other
WO	WO

[xeniaay]

Thank you so much @LivioLanzo  I didn't think of creating a new table to relate the new value type to the old one and then using it in the visualization.  Now problem solved.  Thanks again!