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

Abhijeet_40's avatar
Abhijeet_40
Helper I
1 year ago

It can be done using a pivot table.

This can also be done using a measure.

Total Remaining =
VAR CurrentArea = SELECTEDVALUE('Table'[Area])
VAR CurrentWeek = SELECTEDVALUE('Table'[Week])

RETURN
IF(
    CurrentArea = "Combine",
    CALCULATE(
        SUM('Table'[Remaining]),
        ALL('Table'),  -- Remove all filters
        'Table'[Area] IN { "Asia", "North" },
        'Table'[Week] = CurrentWeek
    ),
    SUM('Table'[Remaining])
)