Forum Discussion

chamue329's avatar
chamue329
Icon for Helper II rankHelper II
6 years ago

Running total value from latest date with multiple category groups

Hi, apologies if this solution exists out there. I spent some time going through various posts but couldn 't find a solution.  I have a time series table grouped by Country, Province and Combined Key...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi chamue329 ,

Please try to create a measure as below:

Measure = CALCULATE(SUM('Table'[Cases]),FILTER('Table','Table'[Date]=MAX('Table'[Date])))

Best Regards

Rena

chamue329's avatar
chamue329
Icon for Helper II rankHelper II
6 years ago

AnonymousI tried your measure and get a "[blank]" for my result.  I'm not sure what I'm doing wrong.  Here is my script:

 

Latest Tot Cases = CALCULATE(SUM('Global Time Series'[Cases]),FILTER('Calendar_B','Calendar_B'[Date]=MAX('Calendar_B'[Date])))
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi chamue329 ,

    Could you please provide the screen shot with structures of table Global Time Series and Calendar_B and some sample data? It needs to include field names and existed relationship between these two tables just like as below screen shot. It is better if you can share your PBIX file by uploading to OneDrive for Business.

    Best Regards

    Rena