Sumx with maxx wrong total

[Dennis_Pedersen]

Hi

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

B2B leads latest2 =

sumx(values(ActiveCampaign[campaign_segmentid]);

MAXX(

    TOPN(

        1;

        'ActiveCampaign';

        'ActiveCampaign'[campaign_segmentid];

    );

    'ActiveCampaign'[campaign_send_amt]

))

[Dennis_Pedersen]

thanks anyone with a  solution to my specified formula?

[Greg_Deckler]

@Dennis_Pedersen 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]

Thanks there are not much more columns than that, but still th total is not correct ?

See below

[Greg_Deckler]

@Dennis_Pedersen First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This 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/63376

Also, 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/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8