Forum Discussion

smedina_25's avatar
smedina_25
New Member
7 years ago

Totals not adding up

Hi All I made a repport that has row and column subtotals and the row (althoug PBI says is column) totals are not adding up. Here is the measure that I did for the calculation of totals:

 

m_Total = var _table = SUMMARIZE(Query1,Query1[Major],"_value",[m_Single]) return IF(HASONEVALUE(Query1[Major]),[m_Single],SUMX(_table,[_value]))

 

 

 

 

Need Help

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi smedina_25 ,

     

    I tested with simple dataset, both column total and row total add up values correctly.

     

    For the unexpected result, it might be related to your source dataset. Please provide sample data of 'Query1', other linked tables if existing and the formula of [m_Single]. How to Get Your Question Answered Quickly

     

    Best regards,

    Yuliana Gu

    • smedina_25's avatar
      smedina_25
      New Member
      7 years ago

      Thanks! I'll try to get the data, in the meantime, I forgot to mention that the table on the screenshot was filtered data, without the filters the totals are ok.

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee
        7 years ago

        Hi smedina_25 ,

         

        Please show sample data in source table 'Query1' and how you filter the matrix.

         

        Regards,

        Yuliana Gu