Display Sum in each Row

[AllanBerces]

Hi good day,

pls need assistance, can anyone correct my calculated column. I have Table 1 where i get the value and display the value in Table 2. they have common column under Category and both connected to Date Table. 

Current filter output:

REMAINING_HRS = CALCULATE(

                    [Sum of Remaining],

                    FILTER(

                        ALL(BRUNEI_WTI_PROGRESS_YRLY_sql[Task No./Phase]),

                        BRUNEI_WTI_PROGRESS_YRLY_sql[Task No./Phase] = "PRECPRA;NC000172" || BRUNEI_WTI_PROGRESS_YRLY_sql[Task No./Phase]= "PRECPRA;NC000135"),

                    FILTER(

                        ALL(BRUNEI_WTI_PROGRESS_YRLY_sql[Main Cat.]),

                         BRUNEI_WTI_PROGRESS_YRLY_sql[Main Cat.]= "Q")

The sum i correct combine 602 and 119 = 721

What i want is:

Thank you

)

[v-yiruan-msft]

Hi @AllanBerces ,

Please update the formula of calculated column as below and check if that is what you want.

REMAINING_HRS =
CALCULATE (
    [Sum of Remaining],
    FILTER (
        ALLEXCEPT (
            BRUNEI_WTI_PROGRESS_YRLY_sql,
            BRUNEI_WTI_PROGRESS_YRLY_sql[Task No./Phase]
        ),
        BRUNEI_WTI_PROGRESS_YRLY_sql[Task No./Phase]
            IN { "PRECPRA;NC000172", "PRECPRA;NC000135" }
                && BRUNEI_WTI_PROGRESS_YRLY_sql[Main Cat.] = "Q"
    )
)

Best Regards

[AllanBerces]

Hi @v-yiruan-msft 

I used below measure working ok, but when i put in calculated column no value displyed.

CALCULATE(

    [Sum of Remaining],

                KEEPFILTERS(BRUNEI_WTI_PROGRESS_YRLY_sql[Sub-Task Phase] IN { "02 CW-AY PRE DRILL FL", "2nd PRE CPRA" } && BRUNEI_WTI_PROGRESS_YRLY_sql[Main Cat.] = "Q"))

How to do it in calculated column?

Thank you

[v-yiruan-msft]

Hi @AllanBerces ,

Could you please provide the formula of [Sum of Remaining] and some fake data in the table 'BRUNEI_WTI_PROGRESS_YRLY_sql'? It would be helpful to get the solution. Thank you.

Best Regards

[AllanBerces]

Hi @v-yiruan-msft 

Good afternoon

Sum of Remaining = SUM(BRUNEI_WTI_PROGRESS_YRLY_sql[Remaining hours])

and table below.

Everyday the data will override by the current date data. below my data model.

Thank you in advance

[AllanBerces]

Hi @v-yiruan-msft 

Im getting error when i try the calculated column from above.

Thank you in advance