Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
Solved

Combine Sum per Row

Hi good day, Can someone help me on my table, is there a way to sum the two area per row   Asia Week1 + North Week 1 = Combine Week 1 DESIRED OUTPUT Thank you
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    Hi AllanBerces - please check this

     

     

    Actual Remaining =
    IF(
        Input[Area] = "Combine",
        VAR WeekNum = Input[Week No.]
        RETURN
            SUMX(
                FILTER(
                    Input,
                    Input[Area] IN {"Asia", "North"} && Input[Week No.] = WeekNum
                ),
                Input[Remaining]
            ),
        Input[Remaining]
    )
     

     

     

    Hope this would help

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

Hi AllanBerces - I have tried with measure as follows with one table input with above details. 

 

Actual Remaining Measure =
VAR WeekNum = SELECTEDVALUE(Input[Week No.])
RETURN
    CALCULATE(
        SUM(Input[Remaining]),
        Input[Area] IN {"Asia", "North"},
        Input[Week No.] = WeekNum
    )
 
can you please check this.

 

Hope it helps.

 

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago

Hi rajendraongole1 thank you fo the reply but i need calculated column. I tried the one you provided in column but no luck.

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    1 year ago

    Hi AllanBerces - please check this

     

     

    Actual Remaining =
    IF(
        Input[Area] = "Combine",
        VAR WeekNum = Input[Week No.]
        RETURN
            SUMX(
                FILTER(
                    Input,
                    Input[Area] IN {"Asia", "North"} && Input[Week No.] = WeekNum
                ),
                Input[Remaining]
            ),
        Input[Remaining]
    )
     

     

     

    Hope this would help