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.
I've soled the issue of blanks ranking by using the following DAX:
Solved! Go to Solution.
Hi BI_Nooby,
Good Quesiton and my thought is.....
A simple ranks function using allselected like below to get rank
Appreciate a Kudos!
If this helps and resolves the issue, please mark it as a Solution!
Regards,
N V Durga Prasad
Haha I see. While not the most elegant solution, it might indeed be better on performance.
After some more thinking I believe it can be solved elegantly.
The problem is occurring because my Sales table does not have an active way to filter my customer table.
If I can establish a temporary relationship within my measure then I can use my Sales to filter my Customers.
I'll come back to this idea. For now I'll accept a solution.
Hi BI_Nooby,
Good Quesiton and my thought is.....
A simple ranks function using allselected like below to get rank
Appreciate a Kudos!
If this helps and resolves the issue, please mark it as a Solution!
Regards,
N V Durga Prasad
Haha I see. While not the most elegant solution, it might indeed be better on performance.
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 |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |