Measures or Values to Rows instead of Columns in a table/matrix

[Enthusiast_2020]

Problem with visualizing! Does someone know how I can make this "Red"table. I have used matrix visual to make the black table(Amount1, Amount2 are DAX measures), but i do not know how to add this red columns M-1,M-2 that are Measures as well. I can accept 2 solutions:1) red columns added as in photo (in same table), but if this is not feasible 2) red columns could be in separate table, but they need to be aligned in same row as on photo because they are related to Amount1 and Amount 2. Thank you! I appreciate your help!

[Anonymous]

HI @Enthusiast_2020,

As amitchandak said, you can't directly achieve your requirements based on your raw table fields.

For your scenario, you need to create a new table with original column field values and measure names, then you can use this as a column with raw table row category and write a measure formula to lookup correspond values abed on row and column data labels.

If you confused on coding formula, please share some dummy data with expecter result then we can test on it

Regards,

Xiaoxin Sheng

[amitchandak]

@Enthusiast_2020 , not possible on the same table . but you might create a table like this to display

Something like this example. Split of measure 

union (SUMMARIZE(Sales," Measure", "MTD", "This",[MTD],"Last",[LMTD],"Change",[MOM]),
SUMMARIZE(Sales," Measure", "QTD", "This",[QTD],"Last",[LQTD],"Change",[QOQ]),
SUMMARIZE(Sales," Measure", "YTD", "This",[YTD],"Last",[LYTD],"Change",[YOY]))