Forum Discussion
Microsoft EmployeeMULTIPLE MEASURES TO SINGLE COLUMN
table 1:
What I have from Table 1:
What i want: (DESIRED VIEW)
Above are all details, I tried to create 6 measures which are sum of 6 columns in table 1. Then I tried to create a column (DESIRED VIEW) but could not use all 6 measures to fall into one column.
4 Replies
- amitchandak
Super User
utsavpatel , You have the option show on the row in Matrix. where measure can go on row of matrix
refer: https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
But I doubt you can get second column
utsavpatelamitchandak , I already tried that but the problem is what you described. I cant calculate total%. Could you please recommend any other solution.
- amitchandak
utsavpatel , for that you have create table converting measure dimension
example - Check measure are creating both row and column . But this will not take your filters
union(
summarize("Measure","Share of Voice", "YTD",[Share of Voice YTD], "LYTD",[Share of Voice LYTD], "Change %",[Share of Voice %]),
summarize("Measure","SOV Rank", "YTD",[SOV Rank YTD], "LYTD",[SOV Rank LYTD], "Change %",[SOV Rank %])
)- utsavpatel
amitchandak , I am not sure i got what you were trying to say in your last post. Could you please elaborate a bit.
