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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. 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
May PBI 25 Carousel

Power BI Monthly Update - May 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

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