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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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