Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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
Do you want to do that in DAX or in Power Query?
Hi Guys!
I would like to extract (display) the percentage of vaccination for the latest date for each country.
Please the screen below:
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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
18 | |
15 |