Forum Discussion

Faracla's avatar
Faracla
Frequent Visitor
3 years ago

Calculated Column not returning back grand total in a table

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?
 
 



Need Help
Tips and Tricks

2 Replies

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    3 years ago

    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.

  • Faracla's avatar
    Faracla
    Frequent Visitor
    3 years ago

    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?