placing a measure in the first row of a matrix

[dwhittaker1]

Is there a way to emulate the table below in power bi? the sales target and Sales actual rows in the item column are from my data set.The difference and attainment rows would be a calculation.

Below is what my data set looks like

Source	Date	Sales
ACTUALS	########	21133688
ACTUALS	########	21092167
TARGET	########	21666046
TARGET	########	24084542

[Uzi2019 · Accepted solution]

Hi @dwhittaker1 

You can simply achived this by creating seperate measure for Actual, target, diff, % etc.

Try this. I have taken you dataset. and created multiple measures

Actual = CALCULATE(SUM(Sales[ Sales]),Sales[Source]="ACTUALS")

target = CALCULATE(SUM(Sales[ Sales]),Sales[Source]="TARGET")

Diff= target- Actual

then take you value in Matrix. it will look like this.

then change the value setting 

You can create similar pattern of Matrix you mentioned above but trick is each matrics has to be seperate measure. 

I hope I answered your question!