October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
Hi Team,
Im working on a report now that would show ranking based on the Goal Attainment per Manager. I dont quite understand how to use the RANKX. I've tried alot of examples but it doesnt work. my conculsion is that the Column that im trying to Rank is a measure. And all my measure is in a different table.
Below is the formula i tried.
RANK = RANKX(Ampule,calculate(([NRS GA]*.25)+([72Hr GA]*.25)+([Resolved GA]*.20)+([CPC GA]*.20)+([Transfer GA]*.10)),,ASC)
Ampule = Table for all my measures
Calculations = formula to get the Goal Attainment im trying to Rank.
Please let me know if you need additional information from me.
User | Count |
---|---|
105 | |
99 | |
98 | |
86 | |
49 |
User | Count |
---|---|
162 | |
142 | |
132 | |
102 | |
63 |