Issue with running total when last day data is not available

[AjithTravvise]

I have an issue with sum calaculation, when a data is not avaiable for the last day it returns blank. When a Country in country/ Region column does not return a value it shows blank, I wanted the system to shown the last data available. In the below example if i filter by United State the TOTAL TEST should return 6231182.   Currently it returns blank

.

  

[Greg_Deckler]

It's really tough to tell what is going on here or create a test for this. Sample data as text/table, expected output. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[AjithTravvise]

The issues is as below:

     - I have a measure called"TEST COMPLETED" which is the sum filted by date with the MAX value. 

     - The issue is that United States "TOTAL_TESTS"value for the last date is blank, so in report when i filter by contry "UNITED STATES" it shows blank. 

     - If the latest date is blank I wante dthe previous days figure to be shown.

      I hope  I am clear with my request, appreciated your help

[v-diye-msft]

Hi @AjithTravvise 

Kindly try below measure:

Measure 3 = SUMX(FILTER('Table',[Date]=MAX('Table'[Date])),[total_test])

If you'd like to get the previous data when currently is blank, you should try something like this :

https://community.powerbi.com/t5/Desktop/Fill-blanks-with-previous-value/td-p/492501 

If abovenot help, you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.