Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
2 years ago

Display Sum in each Row

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 conn...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
AllanBerces
Post Prodigy
2 years ago

Hi Anonymous 

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

 
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      AllanBerces
      Post Prodigy
      2 years ago

      Hi Anonymous 

      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