Forum Discussion
Put multiple measures into a table grid
- 8 years ago
I was able to figure this out:
First I create a table in Edit Queries for each of my KPI's, one each for "TY" and "LY" (This Year/Last Year). The table just has a Column1 with the number 1 in it.
I place a Measure filtered for TY into the new "TY" table. I also add new Columns, one for the row lable ("Conv") and column lable ("TY"). Finall I add a column that is = to the measure I had just added because the DAX UNION function I will use later doesn't recognize Measures.
I did the same for the "LY" data.
Finally I use a UNION function to append the 2 tables into a 3rd new table so the column labels, row labels and the measure data that is sitting in a column line up. Function is "create new Table" and KPI_Combo = UNION(KPI_Conv_TY,KPI_Conv_LY)
After doing this I can generate the table at the bottom:
Now I can just do the same with other KPI's, i.e. create a table for each and UNION them into the KPI_Combo table.
Hey,
I'm not sure if I understand your requirement correctly but maybe you can the matrix visual a try and then use the option "Show on rows" from values band:
Hopefully this is what you are looking for.
Regards
Tom
So much this! Thank you TomMartens