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.
Hi
Below is my data and last column is the required result. Can anyone please help.
Solved! Go to Solution.
Hi @tameemyousaf ,
You can create the following column
Required result = IF([Count]=0,0, RANKX(FILTER('Table',[Count]=0),[Number],,ASC,Dense))
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @tameemyousaf ,
You can create the following column
Required result = IF([Count]=0,0, RANKX(FILTER('Table',[Count]=0),[Number],,ASC,Dense))
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
I do not understand why you put my measure into the different data and expect to see the same result.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@Jihwan_Kim Thanks for your response. Actually number is the serial number and what if the number is same?
Hi, @tameemyousaf
Thank you for your feedback.
Then, how do you differentiate each row?
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@Jihwan_Kim I will differentiate each row with count column. If count column is showing zero against sigle date and same serial number then the required result should increment the data.
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |