Forum Discussion
lherbert501
Post Prodigy
Post ProdigyCalculation Group to change the view
Hi, Could somebody help me with below. Is it possible to create the below scenario using calculation groups? I want to be able to select the toggle and the view changes whether the matrix is ...
DataInsights
Super User
Super User
One option is to create a field parameter consisting of the two columns Store and Area. Add this field parameter to matrix rows. The measures should calculate properly for either Store or Area (assuming a star schema and measures that aggregate per any dimension column).
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
lherbert501Post Prodigy
Post ProdigyThankyou DataInsights and johnt75 for your reply.
I think I was mixing calculation group up with field parameter 🙂
Thanks