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?
mattd1what's the calculation you added? It's unclear to me in the screenshots which calculation you are adding. Please post the DAX.
I mentioned subtraction of Port - Bench in the note as I didn't think the calc was relevant (it works in one file but not in another). But for info:
[Portfolio (EUR)] - [Benchmark (EUR)]
I am assuming Portfolio (EUR) and BenchMark (EUR) are measures, correct? I was a bit confused since you also used the same names in first column of your tables so I didn't know if you were trying to refer to the row "headers" in your calculation.
I have been trying to reproduce the problem, but everything worked fine after copy/pasting, with or without adding a calculation group into the mix. Is there any chance you would be able to share the PBIX with me?
