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 have table, wherein I need to calculate the value of all products which are ranked in Top 10 .
Table below :-
So the value I am looking for is 38.46.
I have used a meaure to calculate the rank, which is given below:-
Table 1
Products | Value |
A | 15.00 |
B | 10.96 |
C | 2.82 |
D | 2.45 |
E | 1.55 |
F | 1.50 |
G | 1.40 |
H | 1.36 |
I | 0.72 |
J | 0.70 |
K | 0.60 |
L | 0.44 |
M | 0.43 |
N | 0.39 |
O | 0.36 |
P | 0.36 |
Q | 0.29 |
R | 0.29 |
Solved! Go to Solution.
Hi @Diptarup
You can use :
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @Diptarup
You can use :
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
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 |
---|---|
95 | |
94 | |
79 | |
71 | |
64 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |