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,
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.