Forum Discussion
Using data created in PowerBi pivot in new calculated values table
I have created a pivot table in PowerBi. How can I create a new table that uses the data from the pivot table in calculated values? I also need it to be dynamically changing with slicers so that both...
I forgot to mention, I would also like to be able to slice the pivot table so that it dynamically changes the calculated table as well when sliced. For example lets say I would like to slice by name as shown below:
The values in the calculated table should also change because it is now referencing the new sliced pivot table values. So it would be showing the Cumulative vol percent for code A and B for each score for Amy only.