Measure return wrong result when unfiltered

[Faracla]

Dear community
i have a problem with a measure returning wrong result when I unfliter.
I have a slicer called "CarrierName", and when i select a specific carrier, the result of "WeightShareMonth" is showing correct , 98.96%. (screen below)

When I unselect the specific carrier from the slicer, the value of "WeightShareMonth" changes returning 1.14% (screen below)

WeightShareMonth is calculated as per below:

WeightShareMonth =

var test =

SUMX(

    SUMMARIZE(

        DIM_Tenders,

        DIM_Tenders[CarrierCode],

        DIM_Tenders[LaneCode],

        DIM_Tenders[LoadMonth*LaneNumber],

        DIM_Tenders[Mode],

        "x",

        [WeightShareMeasure],

        "y",

        [__FinalShareFullMonth]

    ),

    [x]*[y]

)

var test2=

[WeightShareMeasure]*[__FinalShareFullMonth]

return

IF(

    HASONEVALUE(DIM_Tenders[LoadMonth*LaneNumber]),

    test2,

    ROUNDUP(test,4)

)

Anyone has an advice on how to solve this? When unfiltered the result should be the same 
thanks in advacne

[v-zhangti]

Hi, @Faracla 

Can you provide some sample data about the fields involved in your formula? Sensitive information can be removed in advance.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.