Forum Discussion
Solved
Dynamic Total Measure Dependent on Selected Parameters ?
So I have survey data and for each question/column I have created measure that finds the average. See below for example. My question is, I created a parameter that has each measure so a user is able ...
I have switched my method and am using an unpivoted table now. This method didn't work but granted I didn't provide a copy of the PBIX file so I undertstand I'm limiting the odds of an answer.
hi, Last_Resort_22 ,in your case, not necessary to use a parameter. i providing you one senario and hope this can be help:
load your data in power BI, select category and then unpivot other columns.
projection your category to have a seperate table.
make this category an relationship one to many to survery table attibute.
create a measure call total average:
Total Average = AVERAGEX(Survey,Survey[Value]), put category table to a slicer. and you can slice what you want
above solution for your reference.
best regards.
marco