PowerBI-具有多个条件的累积总计 [英] PowerBI - Cumulative Total with Multiple Criteria

问题描述

PowerBI的新手，请原谅我的描述。我正在使用零售人数传感器的数据集，它为我提供了位置，时间戳和购物者数量的表：

New to PowerBI, so forgive me for the description here. I'm working with a dataset of retail headcount sensors, which gives me a table of locations, timestamps, and a count of shoppers:

Room     TimeStamp     Count_In
123      3/13/2019     8
456      4/4/2019      9
123      3/28/2019     11
123      3/18/2019     11
456      3/22/2019     3
etc...

我是试图计算一段时间内每个房间的运行总计。总体运行总计列很容易：

I'm trying to calculate a running total for each "room" over time. The overall running total column is easy:

C_In =
CALCULATE (
    SUM ( Sheet1[In] ),
    ALL ( Sheet1 ),
    Sheet1[Time] <= EARLIER ( Sheet1[Time] )
)

但是我无法弄清楚如何添加第二个过滤器，请确保只对每个不同的位置求和。

But I'm unable to figure out how to add that second filter, making sure that I'm only summing for each distinct location. Help is appreciated!

推荐答案

您的 ALL 函数将删除 Sheet1 ，请尝试使用 ALLEXCEPT 保留 Room 。

Your ALL function removes all context on Sheet1, try using ALLEXCEPT to keep the row context of the Room.

C_In =
CALCULATE (
    SUM ( Sheet1[In] ),
    ALLEXCEPT ( Sheet1, Sheet1[Room] ),
    Sheet1[Time] <= EARLIER ( Sheet1[Time] )
)

这篇关于PowerBI-具有多个条件的累积总计的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！