Forum Discussion

JBI's avatar
JBI
Frequent Visitor
7 years ago

Create new row in a matrix

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!

Need Help

1 Reply

  • dax's avatar
    dax
    Community Support
    7 years ago

    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