Forum Discussion
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 based upon in this example, the store, or the area.
I don't want to use bookmarks, but I have 18 measures in total and didn't know how this would work in calculation groups. Do you have to include each measure in the group?
Thanks
Liam
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
3 Replies
johnt75Super User
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.
- DataInsights
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
lherbert501Thankyou DataInsights and johnt75 for your reply.
I think I was mixing calculation group up with field parameter 🙂
Thanks