Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Matrix Total displaying wrong value for one column

Hi,

 

I have a matrix report where I have created a measure for values  "Reveue-Expenses", it is working fine for all the columns except the last column, please find the below image for reference 

The Total at the right and bottom pops out wrong values it should be 30,059 insted of 52,180.

Pleasse help.

Thanks in Advance.

Need Help

7 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago
      Forecast = (SUM('Append1'[Actual]) + SUM('Append1'[Forecast Remaining]))
      This is formula i am using in the report as Expense has negative values.
      • PaulDBrown's avatar
        PaulDBrown
        Community Champion
        5 years ago

        Anonymous 

        Try:

        Forecsat = SUMX(Append1, SUM(Append1(Actual) + SUM(Append1(Forecast Remaing))

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi,

       

      I have shared my formula could you please suggest where did i go wrong, itwill help me a lot

  • v-xicai's avatar
    v-xicai
    Community Support
    5 years ago

    Hi Anonymous ,

     

    You may create a new measure like DAX below.

     

    Measure_New=

var _table = SUMMARIZE(Append1, Append1[Acct Type],"_Value", [Forecast] )

return
IF(HASONEVALUE(Append1[Acct Type]), [Forecast], SUMX(_table,[_Value]))

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.