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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

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