Power BI 具有多个列且没有日期列的运行总计

Question

sql 中获取了以下数据

    create table #tbl ([Group] varchar(10), [year] int, scenerio varchar(10), Total money)
    insert into #tbl values
    ('Group1',2010,'Up',5),('Group1',2010,'Up',7),('Group3',2012,'Back',4),
    ('Group2',2016,'Front',10),('Group2',2014,'Back',12),('Group1',2015,'Front',7),
    ('Group2',2016,'base',10),('Group1',2017,'Up',11),('Group1',2018,'Up',10),
    ('Group3',2020,'Middle',5),('Group1',2020,'base',6),('Group1',2015,'Back',8),
    ('Group1',2015,'Back',2),('Group3',2020,'Middle',12)
    select * from #tbl
drop table #tbl

我从power BI 中的 ，我为总计创建了一个 DAX SUM(Data[Total] 对于运行总计

Running Total = CALCULATE(
                 sum(Data[Total]),
              ALLSELECTED(data),Data[year]<= MAX(Data[year]))
 current Output

所需输出

Answer 1

也许：

Running Total =
CALCULATE(
    SUM( Data[Total] ),
    FILTER(
        ALLSELECTED( Data ),
        Data[Group] & "|" & Data[year] & "|" & Data[scenerio]
            <= MIN( Data[Group] ) & "|"
                & MIN( Data[year] ) & "|"
                & MIN( Data[scenerio] )
    )
)