Pourcentage and latest date

[dofrancis3]

Hello Guys!

Please i need your help

I would like to calculate and display the vaccination percentage for only the latest date for each count

Below exemple of my data

[Anonymous · Accepted solution]

Hi @dofrancis3 ,
Thanks for the new data, here are my changes to the second MEASURE:

Percentage = 
CALCULATE(
    MAX('Table'[Number of vaccinated]),
    FILTER(
        'Table',
        SELECTEDVALUE('Table'[Date of vaccination]) = [LastDate]
    )
)

Final output

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Anonymous]

Hi @dofrancis3 ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Create two dax

LastDate = 
CALCULATE(
    MAX('Table'[Date of vaccination]),
    ALLEXCEPT(
        'Table',
        'Table'[Country]
    )
)

Percentage = 
VAR _number = 
CALCULATE(
    MAX('Table'[Number of vaccinated]),
    FILTER(
        'Table',
        SELECTEDVALUE('Table'[Date of vaccination]) = [LastDate]
    )
)
VAR SumByCountry = 
CALCULATE(
    SUM('Table'[Number of vaccinated]),
    ALLEXCEPT(
        'Table',
        'Table'[Country]
    )
)
RETURN
_number / SumByCountry

Final output

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[lbendlin]

Do you want to do that in DAX or in Power Query?

[dofrancis3]

Hi Guys!

I would like to extract (display) the percentage of vaccination for the latest date for each country.

Please the screen below:

[lbendlin]

You can do that with grouping in Power Query

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...