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.