Forum Discussion
Dynamic Total Measure Dependent on Selected Parameters ?
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.
Community SupportHi Last_Resort_22 ,
Sorry for the delayed reply. Thank you for providing the details of your model. You don’t need to create extra dimension tables to get this functionality. With your flat file structure, you can create a measure that will dynamically average only the questions selected in your slicer.
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
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.