Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
The goal is to connected the rank with the total average of completion timeline
I have grouped all the status then created by on the status.
The total average of completion is based on calculation of average total value.
E.g.
Status | Group Status | RANKX (ALL(table),'table'[Group Status),, ASC, Dense)
|
C01 | C01 | 1 |
C02 | C01 | 1 |
C03 | C01 | 1 |
Result
When I click on the C01 status then I will see the value of the calculated total average of completion date.
Thank you so much.
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
Where I am stuck is that I cannot find the right dax measure/calculation. The goal I want is that when i select a any status then the average will appear.
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
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.