Which Column to use in Row in matrix table - TRICKY

[Anonymous]

Hi Experts

i have two columns in my FACT table called created by agent and closed by agent - which column should i use so all my measure work in the row value  (standard table) or whats the best method.

Rows	Measure 1	Measure 2	Measure 3	Measure 4	Measure 5	Measure 6	Measure 7	Measure 8	Measure 9	Measure 10
	Created Agent	Closed Agent	Closed Agent	Closed Agent	Closed Agent	Closed Agent	Closed Agent	Closed Agent	Closed Agent	Created Agent

[v-lionel-msft]

Hi @Anonymous ,

Like this?

If not, Please show me a screenshot of your matrix like this.

Best regards,
Lionel Chen

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

[Greg_Deckler]

@Anonymous - Not sure I am following. Do you need to unpivot your Measure columns? Not at all clear.

[Anonymous]

Hi Greg

In My FACT Table i have two column called Closed by Agent and Created by Agent.  Some of the mesure work fine when i drop into the Row field (satndard Table) the closed by Agent Name, but the Created By Agent Measures don't work and visa versa...