Calculated Column not returning back grand total in a table

[Faracla]

Dear all
i have a problem with a calculated column used in table not showing the total.
The column is"LoadWeek*LaneNumber", in this case i woudl expect to have a total of 59, while shows nothing.
The formula is :

"LoadWeek*LaneNumber =

VAR Total = DIM_Tenders[TotalLoadsWeek]

VAR Percentage = dim_Tenders[LanePercentNoBlank]

VAR Output = Total*Percentage

RETURN Output"

I have tried different thing but I do not get what i want
any suggestions?

[Faracla]

@v-zhangti 
i tried your way but unfortunately the result is not the expected one.
i forgot to mentions that i have a filter on the visual, one on the page and also one on monthyear and year week as per screen attached
perhaps is related to filters?

[v-zhangti]

Hi, @Faracla 

I did my best to restore your data, check out the methods below.

Measure = 
IF (
    HASONEVALUE ( DIM_Tenders[ID] ),
    SUM ( DIM_Tenders[LoadWeek*LaneNumber] ),
    SUMX ( DIM_Tenders, [LoadWeek*LaneNumber] )
)

IF (HASONEVALUE()) can control the output of Total.

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.