Unable to get values from two out of three reports when selecting through a slicer

Orlando Yaguas 1 Reputation point
2021-10-02T21:02:25.337+00:00

I arranged a pivot table with a slicer to view 3 individual reports. It works fine, but some values need to be corrected in one of the reports. The only way to correct those values is to convert them to formulas using CUBE functions. This conversion only allows you to display the values in one report, but not the values in the other reports when selecting through the slicer. So far it has not been possible to display the values from the other two reports, even though I have tried various ways to deal with this problem. Can anyone help me on how to handle this situation?

Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,122 questions
{count} votes