Dynamic Case Status and Aging

[danielh1006]

Hi,

I am trying to create a measure that will be used in an aging table that will tell me the number of "cases" that are Open that works dynamically based on the Date Filter.

Case	Date	Status	Cost
A	1/1/2021	Open	10
B	1/1/2021	Open	10
A	1/4/2021	Open	20
A	1/6/2021	Close	0
B	1/7/2021	Open	20
B	1/12/2021	Close	10

Here is a sample dataset:

Here are the results I'm looking for in 3 different Date Filter scenarios:

Date Filter = 1/2/2021
Case	0-5	6-10	10+
A	1
B	1

Date Filter = 1/7/2021
Case	0-5	6-10	10+
A
B		1

Date Filter = 1/12/2021
Case	0-5	6-10	10+
A
B

This one is a little bit of a head scratcher to me, any help would be greatly appreciated.

Thanks!

Dan

[Stachu]

is this supposed to be a Matrix visual or set of 3 measures 0-5, 6-10, 10+?
Another question is regarding blanks - because of auto-exist feature DAX doesn't show the rows that have no data (like your third example), would it be an issue if it was just empty table?

[danielh1006]

@Stachu This would be a matrix visual so one measure. If there is no data, then I would like for it to be an empty table.