Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Power Bi - Create Measure "Running Total" based on column values, line and stacked column bar chart

Hi all,   I am trying to build a running total measure but have been struggling with the following constraints I have.   My database is as follow: 5 columns: Indicator, Scenario, Asset Name, Dat...
Need Help
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi Anonymous ,

According to your description, do you mean want to get the running total value by date at the current Indicator, Scenario, Asset Name? If so, please try the below formula:

Measure =
SUMX (
    FILTER (
        ALL ( 'Table' ),
        [Indicator] = SELECTEDVALUE ( [Indicator] )
            && [Scenario] = SELECTEDVALUE ( [Scenario] )
            && [Asset Name] = SELECTEDVALUE ( [Asset Name] )
            && [Date] <= MAX ( [Date] )
    ),
    [Value]
)

If it doesn't work, please provide a sample and expected result.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.