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

I have rebuilt this visual with a new pbix file and found I could replicate it by adding a filter on Net Ship U is greater than 0.  I had put this filter in my original matrix because without it I am seeing all products in my Product Dimension table, whether or not they had any sales associated with them.  v-huizhn-msft, when you put a filter on your Net Ship U in the Visual's filters does that allow you to replicate my strange results?

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

I should have added that these rows without values only show up when I added a custom metric to the table:

Item Rank NC$ = RANKX(ALL('Product'[Item Number and Description]),Demand[Total NC$],,DESC)

This is a metric that ranks the items in the matrix by Net Contribution Dollars.

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

    Dave_Gugg   I put  Net Ship U in the Visual's filters, it return the expected result without any issue. Please review the below screenshot.



    Best Regars,
    Angelia

    • 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