Power BI - Highest value of every country

[Hellion]

Hi everyone!

I'm totally new in Power Bi and could use a hand here after a few hous getting nowhere.

I have a table with columns Date, Country, Confirmed, Recovered, Deaths (I bet you realised is about the pandemic!) where the dates are increasing day by day for every country with the number of Confirmed, Recovered and Deaths increasing because they are showing accumulated values. Therefore, the latest date is every the highest value of Confirmed, Recovered and Deaths before going into the next country and starting over again. Like:

Date Country Confirmed Recovered Deaths
22/01/2020 Albania 1 0 0
23/01/2020 Albania 5 3 2
01/02/2021 Albania 500 470 30
23/01/2020 UK 10 8 2
25/07/2020 UK 100 70 30
07/02/2021 UK 1000 800 200

I would like to do 2 things. First, to get only the latest/highest value of every country so I can build a bar chart with every country values. Second, summarise all the values per date to create a timeline.

How can I do this?

Thanks

 

[mart37]

=
VAR Cntry=[Country]
RETURN CALCULATE(MAX(Table1[Deaths]),FILTER(Table1,[Country]=Cntry))

 

[mart37]

Why do want to summarize the values when you have accumulated values?

 

[Hellion]

I don´t want to summarise all values from a country. I´m trying to show in, for example, a bar chart, only the accumulated values, in other words, the last line of every country.