topic Pourcentage and latest date in DAX Commands and Tips

Pourcentage and latest date

dofrancis3 — Fri, 15 Mar 2024 11:08:28 GMT

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

Re: Pourcentage and latest date

lbendlin — Fri, 15 Mar 2024 15:33:25 GMT

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

Re: Pourcentage and latest date

Anonymous — Mon, 18 Mar 2024 05:24:53 GMT

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

Re: Pourcentage and latest date

dofrancis3 — Mon, 18 Mar 2024 16:45:12 GMT

Hi Guys!

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

Please the screen below:

Re: Pourcentage and latest date

lbendlin — Mon, 18 Mar 2024 16:46:17 GMT

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-Forum/ba-p/963216

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/1447523

Re: Pourcentage and latest date

Anonymous — Tue, 19 Mar 2024 01:18:00 GMT

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