Forum Discussion

Dave_Gugg's avatar
Dave_Gugg
Icon for Kudo Collector rankKudo Collector
9 years ago

Getting ridiculously wrong subtotals in matrix visual

I am trying to build a visual with three rows and no columns.  When I add a couple of values that I am bringing in from a data set, the subtotals are either correct for one or the other, not both:  ...
Need Help
Dave_Gugg's avatar
Dave_Gugg
Icon for Kudo Collector rankKudo Collector
9 years ago

v-huizhn-msft, are you using the table or matrix for your test?  I am using the matrix.  

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Dave_Gugg  Sorry for inconvience, I reproduce it using Metrix and it works fine, please review below screenshot.



Best Regards,
Angelia 

  • Dave_Gugg's avatar
    Dave_Gugg
    Icon for Kudo Collector rankKudo Collector
    9 years ago

    v-huizhn-msft, thank you for sticking with this.  The Net Ship $ and Net ship U need to be in the Values section, not the Rows section.

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Dave_Gugg I am very gald to help you. The Net Ship $ and Net ship U are placed in the Values section. Please the below screenshot.

       

       

      If you have any question, please feel free to ask.

      Best Regards,
      Angelia
       

      • Dave_Gugg's avatar
        Dave_Gugg
        Icon for Kudo Collector rankKudo Collector
        9 years ago

        Your set up looks the same as mine.  The only other thing that I can think to check is I am using Direct Query.  Are you using Direct Query or loading your data?