Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## Measure to sum a group of values in a column

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
1 ACCEPTED SOLUTION
Solution Sage

@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

Did I answer your question correctly? Mark my answer as a solution!

Proud to be a Datanaut!

2 REPLIES 2
Solution Sage

@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

Did I answer your question correctly? Mark my answer as a solution!

Proud to be a Datanaut!

Regular Visitor

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!

## Helpful resources

Announcements

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors