Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello All,
I have Meetings Completed to Meetings Assigned by employee wise, Dividing Meetings Completed/Meetings Assigned gives me the Ratio.
The Ratio is having Ties with multiple employees,means Emp A,B,C,D,E has Ratio as 1 and if give Top 3 from Numeric Range(What if Parameter) it's showing all the Emp's who is having Ratio 1.
I used the following DAX in Power BI
Help me out on this
TIA
Solved! Go to Solution.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi @likhithar
You can add index column in power query to solve this issue,here are my steps,you can take a reference:
Go into the power query
Then sort met ratio field
Then sort emp name field
Then add index column from 1
Now the data look as:
in visualization,use the index field to create the slicer
Best Regards,
Community Support Team _Isabella
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @likhithar
You can add index column in power query to solve this issue,here are my steps,you can take a reference:
Go into the power query
Then sort met ratio field
Then sort emp name field
Then add index column from 1
Now the data look as:
in visualization,use the index field to create the slicer
Best Regards,
Community Support Team _Isabella
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi @CNENFRNL
Thanks for the Reply..My Requirement is If I select Rank 3, it has to show 3 Employees only who are with 100% in the above scenario(Ex: It might be A,B,C).Is it possible to achieve??
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
User | Count |
---|---|
94 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |