Power Bi DAX: Count rows dynamically and aggregate

Question

I have this sample table:

"Running Total" is a MEASURE (NOT a column), and I need to change this measure such that it works when the date column is filtered.

Current code for "Running Total", which generates the above output: Issue with the code: It does not work when the "date" column is filtered using a slicer.

I need this output when the date filter is set to 2018-01-01-2023-01-01 for example:

As you can see, 2017 dates are removed, therefore the "Running Total" measure is adjusted accordingly.

How to achieve this?

davidebacci · Accepted Answer · 2022-12-04 13:47:08Z

1

Replace ALL() with ALLSELECTED()

answered Dec 4, 2022 at 13:47

davidebacci

31.5k4 gold badges20 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Power Bi DAX: Count rows dynamically and aggregate

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related