Forum Discussion
Post ProdigyCalculation Group to change the view
I think a field parameter would work here. Create a new field parameter and add the store and area columns to it. Use the field parameter in the table or matrix visual, and it will update as users make their selection in the slicer.
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
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
Post ProdigyThankyou DataInsights and johnt75 for your reply.
I think I was mixing calculation group up with field parameter 🙂
Thanks