Display Sum in each Row

Question

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.&nbsp;Current filter output:REMAINING_HRS = CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Sum of Remaining],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALL(BRUNEI_WTI_PROGRESS_YRLY_sql[Task No./Phase]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BRUNEI_WTI_PROGRESS_YRLY_sql[Task No./Phase] = "PRECPRA;NC000172" || BRUNEI_WTI_PROGRESS_YRLY_sql[Task No./Phase]= "PRECPRA;NC000135"),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALL(BRUNEI_WTI_PROGRESS_YRLY_sql[Main Cat.]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BRUNEI_WTI_PROGRESS_YRLY_sql[Main Cat.]= "Q")&nbsp;The sum i correct combine 602 and 119 = 721&nbsp;What i want is:&nbsp;Thank you)&nbsp;

anonymous · Answer

Hi&nbsp;AllanBerces&nbsp;,
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" }
                &amp;&amp; BRUNEI_WTI_PROGRESS_YRLY_sql[Main Cat.] = "Q"
    )
)
Best Regards

allanberces · Answer

Hi&nbsp;Anonymous&nbsp;Im getting error when i try the calculated column from above.Thank you in advance

allanberces · Answer

Hi&nbsp;Anonymous&nbsp;I used below measure working ok, but when i put in calculated column no value displyed.&nbsp;CALCULATE(&nbsp; &nbsp; [Sum of Remaining],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KEEPFILTERS(BRUNEI_WTI_PROGRESS_YRLY_sql[Sub-Task Phase] IN { "02 CW-AY PRE DRILL FL", "2nd PRE CPRA" } &amp;&amp; BRUNEI_WTI_PROGRESS_YRLY_sql[Main Cat.] = "Q"))How to do it in calculated column?&nbsp;Thank you&nbsp;

anonymous · Answer

Hi&nbsp;AllanBerces&nbsp;,
Could you please provide the formula of&nbsp;[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.
&nbsp;
Best Regards

allanberces · Answer

Hi&nbsp;Anonymous&nbsp;Good afternoonSum 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&nbsp;

Forum Discussion

Display Sum in each Row

5 Replies

Related content

Measure displaying last week sum

Running sum

Filtering a Sum

Improper Sum with slicer

Image display in Power bi report