Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Fistachpl
Helper II
Helper II

How to copy values calculated by a measure?

Hello,

 

I have a question. I have a table of Team members:

NameNumber of goalsNumber of assistsRank by goalsRank by Assists

Smith

53calculated by measurecalculated by measure
Quincy312calculated by measurecalculated by measure
Clarence94calculated by measurecalculated 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?

 

1 REPLY 1
amitchandak
Super User
Super User

@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.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors