Matrix Show On Rows - Measure Pivot

[Anonymous]

Is there a way I can pivot by measures that are displayed 'on rows' in the matrix?

Here is the context.

I have 5-6 measures that calculate week by week how many sales leads flowed through the sales process, like below.  The database contains a timestamp for each stage which I have inactive relationships that I write measures for to count up the tallys. 

	Week 1	Week 2	Week 3
Stage 1 Counts	3	1	4
Stage 2 Counts	2	0	2
Stage 3 Counts	4	1	2

I now need to add a layer with lead stage counts by Source by week, and the requestors have asked for a format such that the Measures would be the pivot, like so:

		Week 1	Week 2	Week 3
Stage 1 Counts
	Web	2	1	0
	Email	1	0	2
	MarketingEvent	0	0	2

I can't figure out a way to get this to work, I can get the Source as the Pivot but that looks fairly messy as it duplicates each set of measures for every marketing source and becomes cumbersome quickly. 

[Anonymous]

Hi  @Anonymous ,

In my opinion, measures are not used for perspective, but are data for indicator aggregation. You can put measures on rows in a matrix in power Bi through the wonderful blog post written by Matt Allington, or try to carry out row column rotation in pivot column in power query

Link：

https://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/

Best Regards,

Liu Yang

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