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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register 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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.