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  ...
Need Help
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.