Matrix Total displaying wrong value for one column

[Anonymous]

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.

[v-xicai]

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.

[amitchandak]

@Anonymous , can you share the formula you are using.

Refer if this can help: https://www.youtube.com/watch?v=ufHOOLdi_jk

[Anonymous]

Hi,

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

[Anonymous]

Forecast = (SUM('Append1'[Actual]) + SUM('Append1'[Forecast Remaining]))

This is formula i am using in the report as Expense has negative values.

[PaulDBrown]

@Anonymous 

Try:

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

[Anonymous]

Hey Thank you so much for the reply but It did not work it is giving me wrong values, I have used the formula you suggested and created measure "New Forecast"

[PaulDBrown]

@Anonymous 

Without seeing how the model is set up and the tables used it is a bit of a guessing game, However, let's try the following. Assuming your period column is from a Period Table[period], try:
New forecast = SUMX(Period Table, SUM(Append1(Actual) + SUM(Append1(Forecast Remaing))

If that doesn't work, can you show the hierarchy in the matrix, the model and relationships within?