Create new row in a matrix

[JBI]

Hi Guys,

I have data from a table like this:

With a couple of measures I create results like this:

I want to sum all three Proposals (Proposals_1Cost + Proposals_2Cost + Proposals_3Cost) as one blanket "Proposals" and have it display as one of the FieldNames. 

A measure of summing the three doesn't work, because it gets placed in a new column. I need the result almost to be one of the "FieldNames".

Thanks in advance!

[dax]

Hi JBI,

You could create a new table like below

Then create a measure like below

Measure 4 = SUM(Table2[quantity])
Measure 3 = if(min(Table2[name])=MIN(Table3[Column1]),SUM(Table2[quantity]),sumx(FILTER(ALLSELECTED(Table3),Table3[Column1]="a" ||Table3[Column1]="a2"||Table3[Column1]="a3"),[Measure 4]))

Measure 5 = if(HASONEVALUE(Table3[Column1]),[Measure 3],sumx(ALLSELECTED(Table3[Column1]),[Measure 3]))

Best Regards,

Zoe Zhi

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