Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I have a table chart it shows some kpi's for a customers. I set filter to show only top 10 customers on one of my kpi. Normally it works fine but when the kpi values is equal for more then one customer the table shows more than 10 value. I don't want it. I always want to see only 10 customer on my chart. How can i fix that ? Any idea ? and please tell me if anything not clear.
Solved! Go to Solution.
Hi @Anonymous
By my test, you need to create a calculated column using RANX function. The following method you can have a try.
Rank = RANKX(Table1,Table1[ID])
Note: You have to choose one column which doesn’t contain duplicate values in this formula. And RANX function defaults to reverse order.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
By my test, you need to create a calculated column using RANX function. The following method you can have a try.
Rank = RANKX(Table1,Table1[ID])
Note: You have to choose one column which doesn’t contain duplicate values in this formula. And RANX function defaults to reverse order.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
is there anyone have idea ?
It's to important for me
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |