Measure in matrix row level

[Saxon10]

I have a two columns in data table which is area and result. I created new measure in same table which is status and I would like to bring it the area in column level, result in value column and new measure (status) row level in matrix visual table.

AREA	RESULT
DD1	WIN
DD1	WIN
DD1	WIN
DD1	WIN
DD1	WIN
DD1	WIN
DD2	LOSS
DD3	LOSS
DD3	LOSS
DD3	LOSS
DD3	LOSS
DD4	LOSS
DD5	LOSS
DD6	LOSS
DD7	LOSS
DD8	LOSS

[sevenhills · Accepted solution]

You cannot add a measure in matrix row. (Like @Mohammad_Refaei said )

Have you every looked into "Show on rows" functionality for your needs? Just curious. 

[Saxon10]

Thanks for your reply. I tried the option and its works for value column not im row level. 

[sevenhills]

It has limitations and not work for all scenarios.
Shared so that it is worth a look and see if you could change your visualization.
Sorry, if this does not help your scenario. 

[Saxon10]

Hi,

Thanks for your response and update. 

[sevenhills]

I was thinking about your request and thought will share this article. Not sure whether this fits, worth a read

https://exceleratorbi.com.au/building-a-matrix-with-asymmetrical-columns-and-rows-in-power-bi/

Basically, the article talks about and bridges some of the issues we normally encounter. Check it out and see if it fits for your needs.

[Mohammad_Refaei]

You cannot add a measure in matrix row.

You have to add a data field (column).

[Saxon10]

thanks for your quick response.