Running Total Part 2

Lucy64

In your scenario, your running total calculation is over all week numbers. When you select a week number in slicer, it just filter each fact data for your selected week number. If you want to show the correct running total pct, you also need to have your calculation group on "Week Number". Just add the "Week Number" column in ALLEXCEPT() function.

RunningTotal =
MAXX (
    vwScalesDataFabricationNetValue,
    SUMX (
        FILTER (
            SUMMARIZE (
                CALCULATETABLE (
                    vwScalesDataFabricationNetValue,
                    ALLEXCEPT (
                        vwScalesDataFabricationNetValue,
                        vwScalesDataFabricationNetValue[BuildingName],
                        vwScalesDataFabricationNetValue[WeekNumber]
                    ),
                    ALLSELECTED ( vwScalesDataFabricationNetValue[BuildingName] )
                ),
                vwScalesDataFabricationNetValue[MachineName],
                "NetVal", SUM ( vwScalesDataFabricationNetValue[Fabrication Net Value] )
            ),
            [NetVal]
                >= SUMX (
                    FILTER (
                        CALCULATETABLE (
                            vwScalesDataFabricationNetValue,
                            ALLEXCEPT (
                                vwScalesDataFabricationNetValue,
                                vwScalesDataFabricationNetValue[BuildingName],
                                vwScalesDataFabricationNetValue[WeekNumber]
                            ),
                            ALLSELECTED ( vwScalesDataFabricationNetValue[BuildingName] )
                        ),
                        vwScalesDataFabricationNetValue[MachineName]
                            = EARLIER ( vwScalesDataFabricationNetValue[MachineName], 2 )
                    ),
                    vwScalesDataFabricationNetValue[Fabrication Net Value]
                )
        ),
        [NetVal]
    )
)

Regards,