Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a measure that is multiplying values of 3 measues (each are each sum of items in that are in 3 different tables):
Age is in "Tombstone table"
Last odometer reading is in "Trip table"
Operating repair costs is in "Expenses table"
Solved! Go to Solution.
Hi @TRK ,
Since you did not provide a specific data template, you can refer to my model. The following atestmeasure is a measure, filtered according to slicer, rank is sorted according to atestmeasure, return value unchecked data.
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Hi @TRK ,
Since you did not provide a specific data template, you can refer to my model. The following atestmeasure is a measure, filtered according to slicer, rank is sorted according to atestmeasure, return value unchecked data.
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Something along the lines of:
RANK = RANKX(ALLSELECTED (Table), [Surplus Weighted Values])
Proud to be a Super User!
Paul on Linkedin.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |