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

Helper I

## Show Badge According to Points

Hello Everyone

i have 2 table one table have different badge and 2nd table have Employee with value

Badge table

 Points Badge 100 image link of badge 1 200 image link of badge 2 300 image link of badge 3 400 image link of badge 4

badge table look like this

Employee table

 Employee Points Employee1 150 Employee2 100 Employee3 250 Employee4 350 Employee5 500

employee table look like this now when i create relationship between these 2 table one to one relationship create problem with one to one is only work when both table have unique value. badge image only show when unique value match like 100 points have level 1 image it's only showing when employee have same points what i want is from 1 to 100 level 1 bagde from 101 to 200 level 2 bagde and so on

any idea how i can do that i try one to many and many to one relation but nothing change badge image not even show when i change relation to one to many or many to one with one to one i need unique value in both table but in employee table vlaue not same it's change everyday

if anyone can help me this thank you

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Add a calculated column with the following DAX code to your Employee table.

``````BadgePoints =
VAR P = Employee[Points]
VAR Result =
SWITCH(
TRUE(),
P>=100 && P<200,100,
P>=200 && P<300,200,
P>=300 && P<400,300,
P>=400,400,
0)
RETURN
Result``````

This will give you the following result.

Then create the relationship between this new calculated column and your Badge table.

2 REPLIES 2
Anonymous
Not applicable

Add a calculated column with the following DAX code to your Employee table.

``````BadgePoints =
VAR P = Employee[Points]
VAR Result =
SWITCH(
TRUE(),
P>=100 && P<200,100,
P>=200 && P<300,200,
P>=300 && P<400,300,
P>=400,400,
0)
RETURN
Result``````

This will give you the following result.

Then create the relationship between this new calculated column and your Badge table.

Helper I

thank you

## Helpful resources

Announcements

#### 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.

#### Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

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

#### Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors