Sumx with maxx wrong total

Question

Hi&nbsp;Can anyone help correct this measure?Each campaign is given me the correct figure as I only want the latest.But the total is wrong, it should be 5.462 istead of 6.952&nbsp;&nbsp;B2B leads latest2 =sumx(values(ActiveCampaign[campaign_segmentid]);MAXX(&nbsp; &nbsp; TOPN(&nbsp; &nbsp; &nbsp; &nbsp; 1;&nbsp; &nbsp; &nbsp; &nbsp; 'ActiveCampaign';&nbsp; &nbsp; &nbsp; &nbsp; 'ActiveCampaign'[campaign_segmentid];&nbsp; &nbsp; );&nbsp; &nbsp; 'ActiveCampaign'[campaign_send_amt]))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

greg_deckler · Answer

Dennis_Pedersen&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

dennis_pedersen · Answer

thanks anyone with a&nbsp; solution to my specified formula?

greg_deckler · Answer

Dennis_Pedersen&nbsp;It's difficult to know the specific solution becasue I'm not sure of exactly what your hierarchy is within your matrix. I see that you have a campaign_segmentid column and a Date column but it looks like there are additional levels to your hierarchy. So, without all of the information necessary, it's difficult to know the specific solution that will work in your case.

dennis_pedersen · Answer

Thanks there are not much more columns than that, but still th total is not correct ?&nbsp;See below&nbsp;&nbsp;

Forum Discussion

Sumx with maxx wrong total

4 Replies

Related content

Wrong Total in SUMX

SumX? - cumulative running total

¿SumX? - Total acumulado

Wrong Total

Sumx totals wrong