Forum Discussion
Share your thoughts on visual calculations (preview)
Tried to use Vis Calc on a matrix where I had switched axis. I'm running Version: 2.137.952.0 64-bit (October 2024)
This worked fine in one PBI file but then copy paste the visual with the calc to another (pointing at same semantic model) went all screwy. If I remove the calc the switched matrix looks fine. If I add the calc back it doesn't ...
Note the columns are a Calculation Group table.
Above is visual without calculation. If I now add a subtraction of Port - Bench ... it goes like this:
The calculation is working. This file is a PBIP. I have tried copying to another PBIX too ...
Here in another (PBIX) file - all working (note I called the field __ in this one rather than "Relative" as above):
When I copy paste this to a brand new unsaved file:
It's all flattened out. If I remove the Calculation I get this:
Help?