Matrix Totals Off

Question

I've been Googling and trying several different measures but still can get these totals right. For the 'Item 1' 49.75 the below screenshot is showing all the rows with the correct amount but the header Totals are off. Any help would be greatly appreciated!

Here are my measures:

Total Est Lnft = SUMX(FCI_FORECAST_MOO,FCI_FORECAST_MOO[EST_LNFT])*SUMX(FCI_FORECAST_PLYS,FCI_FORECAST_PLYS[PLYS])

Est Rolls = ROUNDUP(IFERROR('Measures Table'[Total Est Lnft]/SELECTEDVALUE(FCI_FORECAST_PROD_ID[AVG_LNFT]),0),0)

greg_deckler · Answer

Jamey&nbsp;First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742eThis looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907Also: https://youtu.be/uXRriTN0cfYAnd: https://youtu.be/n4TYhF2ARe8

Forum Discussion

Matrix Totals Off

1 Reply

Related content

Totals in Matrix

Matrix Totals Incorrect

Formatting grand total in matrix

Matrix Row Totals

Matrix Adding total from previous Group