Forum Discussion
Showing measure in rows
Hello Ibendlin,
Thank you for your solution. However, I have found a better approach that I'd like to share here.
To begin, I wanted to visualize both data columns (column 1, column 2, column 3, fac1, and fac2) and the measure I created (Measure) in a matrix visualization.
What I did was add an additional column in the productivity table using Power Query. I named this column "Measure" and inserted a value of 0. Afterward, I pivoted the table and grouped it by the productivity table with fac1, fac2, and the new column I created. Then, I appended this table with the speed table. In the speed table, I also pivoted and grouped by column 1, column 2, and column 3.
Below is the resulting table I created using Power Query.
I created this measure and drag it in the value field of Matrix:Measure=if(SELECTEDVALUE(Append1[Attribute])="Measure",CALCULATE(SUM(Append1[Value]),Append1[Attribute]="Fac1")/CALCULATE(SUM(Append1[Value]),Append1[Attribute]="Fac2"),CALCULATE(SUM(Append1[Value]))
and I drag the attribute to the row of matrix and city to the column of matrix.
something like this?
Hello Ibendlin,
Thank you for your solution. However, I have found a better approach that I'd like to share here.
To begin, I wanted to visualize both data columns (column 1, column 2, column 3, fac1, and fac2) and the measure I created (Measure) in a matrix visualization.
What I did was add an additional column in the productivity table using Power Query. I named this column "Measure" and inserted a value of 0. Afterward, I pivoted the table and grouped it by the productivity table with fac1, fac2, and the new column I created. Then, I appended this table with the speed table. In the speed table, I also pivoted and grouped by column 1, column 2, and column 3.
Below is the resulting table I created using Power Query.
I created this measure and drag it in the value field of Matrix:
and I drag the attribute to the row of matrix and city to the column of matrix.