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.
Thanks in Advance.
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]))
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.
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"
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?
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.