Forum Discussion
A repeating column in the matrix
Hi, I have a matrix with two rows that are used as a header, the first header row uses as a group under which there are several groups. Every time I add one new group, the same group appears to me again and again and again. There is no connection between the groups and therefore there is no data either and the other column is empty. How do I cancel this connection?
2 Replies
- MFelix
Super User
Hi Livnat ,
In this case without knowing how the metrics are setup and the calculations done believe waht you are missing is group that allows you to have the calculation merged between the groups for example if you have a table similar to this:
Header 1 Header 2 Group1
Low Level1 Group1 Low Level2 Group2 Low Level3 Group2 Low Level4 Now if you add a switch stament similar to this:
Values= SWITCH(SELECTEDVALUE(Table[Header 2]), "Low Level1", [Metric1], "Low Level2", [Metric2], "Low Level3", [Metric3], "Low Level4", [Metric4] )The using this metric on the values of the matrix and the table values on the headers you will get the values has you need.
What is the metric used for in your example? And where do I put the measure I created? in columns?
