Sum Column

[Nosh10]

Hello, 

I'm looking to create a matrix table that includes a SUM FTE column (see attached) that does the following:

How many ETFs are in surface

How many ETFs are in construction

How many EFTs are in landscaping

Since I'm dealing with a dimension and measure to add to a table, I'm not sure how to move forward. Thank you. 

Platform	Product Line	Team	Sum FTEs	Engineer	Project Manager	Designer
Surface	Facility and Equipment Operations Systems	EC Saas 2	7.5	0	0.5	0
Construction	aPaaS	Dev	14	0.2	0.5	0.3
Landscape	aPaaS	OC Dev	7.7	0.2	0.5	0

[V-lianl-msft]

Hi @Nosh10 ,

Could you show us your sample data and expected results? So that we can know your scenario better.

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

[Greg_Deckler]

What are we looking at source data or output? If source, provide output, if output, provide source.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490