Forum Discussion

Last_Resort_22's avatar
Last_Resort_22
Regular Visitor
1 year ago
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 ...
  • Last_Resort_22's avatar
    Last_Resort_22
    1 year ago

    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.

Last_Resort_22's avatar
Last_Resort_22
Regular Visitor
1 year ago

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.

V-yubandi-msft's avatar
V-yubandi-msft
Icon for Community Support rankCommunity Support
1 year ago

Thank you for the update. I appreciate your perspective. Switching to an unpivoted table seems reasonable for managing dynamic data.

As you mentioned, it's difficult to give a specific answer without the PBIX file. If you can share a simplified version, a screenshot of your query steps, or the DAX logic, it would help provide more accurate suggestions.

 

Thanks for your effort.