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
tlmf2020
Regular Visitor

Dynamic score base on combine keys & values

hi everyone, 

I have very complicate case need to be work on PowerBI. here it is high level logic of case.
I have 2 tables

Table 1: key-value (have 16 keys & values)

tlmf2020_4-1721564150674.png

 

 

 

Table 2: Score

tlmf2020_0-1721566249353.png

 

 

all value of keys can change by parameter

What if key1 value is = GENERATESERIES(0, 100, 1)

tlmf2020_5-1721564632425.png

 

we expectation show correct new score when value of each key change

(my current dashboard doesnot show correct New Score)

tlmf2020_1-1721566367207.png

 

 

Any helps to correct visualize?

 

I am new of this community, so I dont know how to add powerBI test file and test data here, any suggestions?

 

 

2 REPLIES 2
tlmf2020
Regular Visitor

thanks @sunny18pc , 
the number of keys on each record Priority can change based on data. 

sunny18pc
Regular Visitor

Hi

 

What I get here that the cases where multiple keys are used you need to add both key values so that you can get the updated values. 

Hope this would help resolving your issue.

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