Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello,
I have a question. I have a table of Team members:
| Name | Number of goals | Number of assists | Rank by goals | Rank by Assists |
Smith | 5 | 3 | calculated by measure | calculated by measure |
| Quincy | 3 | 12 | calculated by measure | calculated by measure |
| Clarence | 9 | 4 | calculated by measure | calculated by measure |
To evaluate a player I calculate the rank by goals and by assists (these are measures) which are calculated in this way:
[number of goals scored by a player] / [maximum goals from all players] * [rank value]
Of course the evaluation of the player is based: 60 points goals and 40 points assists.
For player called smith rank by goals: 5/9*60 = 33,33 and rank by assists: 3/12*60 = 15 = 48,33 total.
And here is my question. I want to copy values calculated in rank by goals and rank by goals to other different visualizations. How do I do that?
@Fistachpl , what do mean by copy value?
I think Dynamic segmentation can help
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.