Forum Discussion
utsavpatel
Microsoft Employee
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...
amitchandak
Super User
Super Userutsavpatel , 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 %])
)
utsavpatelMicrosoft Employee
Microsoft Employeeamitchandak , I am not sure i got what you were trying to say in your last post. Could you please elaborate a bit.