cancel
Showing results for
Did you mean:
Post Patron

## 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.

7 REPLIES 7
Community Support

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.

Super User IV

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

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

Proud to be a Super User!

Post Patron

Hi,

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

Post Patron
Forecast = (SUM('Append1'[Actual]) + SUM('Append1'[Forecast Remaining]))
This is formula i am using in the report as Expense has negative values.
Super User II

Try:

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

In doing so, you are also helping me. Thank you!

Proud to be a Super User!

Post Patron

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"

Super User II

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?

In doing so, you are also helping me. Thank you!

Proud to be a Super User!

Announcements

#### Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks