Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Column Total is not displaying correctly in Matrix visual

Hi ,

    We are facing this type of issue. Please solve this query. 

 

 

A

B

C

Total

 

5

20

1

45798710

 

6

34

2

546799

Total

11

54

3

 

 

Thanks

Godasu

Need Help

8 Replies

  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion
    7 years ago

    We need more information for this one, please provide some images of the table and the calcuations that you're using. 

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    hi, Anonymous 

    This looks like a measure totals problem. Very common. See this post about it
    https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

    Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
    https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

     

    If you still have problem, please share a simple sample pbix file or some sample data.

     

    Best Regards,

    Lin

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

       

       

       

       

      brand

      col1

      col2

      col3

      col4

       

      product

      In coreecttotal

      Xyz

      AD

      HG

      lk

      measure1

      5

      95

      measure2

      5

      95

      measure3

      0

      0

      measure4

      0

      0

      Total

      Total measure1

      5

      95

      Total measure2

      5

      95

      Total measure3

      0

      0

      Total measure4

      0

      0

       

      please find the sample report 

       

      thanks

      Godasu

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Value_unit  = IF(SELECTEDVALUE('Unit'[Value])="One",sum(Table1[Detail.qty]),if(SELECTEDVALUE('Unit'[Value])="Two",(sum(Table1[Detail.qty]) * SUM('CG'[RET_Size] )),IF(SELECTEDVALUE('Unit'[Value])="Three",(sum(Table1[Detail.qty]) * SUM('CG'[RET_Size]) * SUM('CG'[RET_One]))/10)))

       

      Could you please modify the above measure to get the correct subtotals..

      • tex628's avatar
        tex628
        Icon for Community Champion rankCommunity Champion
        7 years ago
         
        Measure =
        Value_unit = IF(SELECTEDVALUE('Unit'[Value])="One",
sum(Table1[Detail.qty]),
if(SELECTEDVALUE('Unit'[Value])="Two",
(sum(Table1[Detail.qty]) * SUM('CG'[RET_Size] )),
IF(SELECTEDVALUE('Unit'[Value])="Three",
(sum(Table1[Detail.qty]) * SUM('CG'[RET_Size]) * SUM('CG'[RET_One]))/10,
IF(SELECTEDVALUE('Unit'[Value])=BLANK(),
Calculate(sum(Table1[Detail.qty]),'Unit'[Value]="One") 
+
Calculate(sum(Table1[Detail.qty]) * SUM('CG'[RET_Size]),'Unit'[Value]="Two")
+
Calculate(sum(Table1[Detail.qty]) * SUM('CG'[RET_Size]) * SUM('CG'[RET_One])/10,'Unit'[Value])="Three", BLANK()
))))