cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Dynamic Case Status and Aging

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.

CaseDateStatusCost
A1/1/2021Open10
B1/1/2021Open10
A1/4/2021Open20
A1/6/2021Close0
B1/7/2021Open20
B1/12/2021Close10

Here is a sample dataset:

 

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

Date Filter = 1/2/2021   
Case0-56-1010+
A1  
B1  

 

Date Filter = 1/7/2021   
Case0-56-1010+
A   
B 1 

 

Date Filter = 1/12/2021   
Case0-56-1010+
A   
B   

 

 

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

 

Thanks!

Dan

2 REPLIES 2
Community Champion
Community Champion

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?



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Proud to be a Super User!

@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.

 

 

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.