cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
neelofarshama
Post Patron
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 

neelofarshama_0-1601046386144.png

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.

7 REPLIES 7
v-xicai
Community Support
Community Support

Hi @neelofarshama ,

 

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
Super User IV
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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Hi,

 

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

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

@neelofarshama 

Try:

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





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






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"

 

neelofarshama_0-1601205981526.png

 

@neelofarshama 

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?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

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

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors