Forum Discussion
Microsoft EmployeeShare your thoughts on visual calculations (preview)
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)]
Microsoft EmployeeI 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?
Hi thanks a lot for responding.
It's funny how it worked in one file but not in another (even creating from scratch in the other file).
Yes, those names (Portfolio (EUR) and Benchmark (EUR)) are the renamed measures on the visual.
I am wondering if there is some file version thing going on - maybe the first time I did it using September release, then one of my colleagues prepared a separate PBIP file for our project perhaps using later release (or earlier) ...
Sharing the PBIX might be challenging from our development environment. Very sensitive client data, and model separated from report files etc. Could do an online Teams call or something and look over it together if any use to you?
Thanks for taking time to help.
- jeroenterheerdt
I'll send you a direct message to exchange details so we can do some screensharing.