Forum Discussion

jeroenterheerdt's avatar
jeroenterheerdt
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

Share your thoughts on visual calculations (preview)

Hit "Reply" and let us know what you think of visual calculations! To learn more about this feature, please visit the blog post or our documentation.   Here are some areas that we'd like to hear ab...
General Comment
mattd1's avatar
mattd1
Frequent Visitor
2 years ago

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?

jeroenterheerdt's avatar
jeroenterheerdt
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

mattd1what's the calculation you added? It's unclear to me in the screenshots which calculation you are adding. Please post the DAX.

  • mattd1's avatar
    mattd1
    Frequent Visitor
    2 years ago

    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)]

     

     

    • jeroenterheerdt's avatar
      jeroenterheerdt
      Icon for Microsoft Employee rankMicrosoft Employee
      2 years ago

      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?

      • mattd1's avatar
        mattd1
        Frequent Visitor
        2 years ago

        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.