Quartile based on Range of Each Banding

[Brainfried88]

Hi guys, 

Seeking your help for a dax solution on quartile based on a range for various banding. i have 2 sets of tables - 1 showing the country and scoring, another showing the tier. My aim is to return the quartile, based on the tier it is in. (E.g Country A will be in Tier 1, Q4. Country B is Tier 3, Q1)

thanks! 

Tier
1	1.6
2	2.1
3	2.4
4	3.05
5	4.0

Country	Score
A	2.05
B	2.55
C	1.83
D	3.08

[Brainfried88]

@Greg_Deckler- not quite the same. In your example, it looks like a straightforward quartile dax from a range of numbers. In my case, I want to split each tier to having its own Q/2/3/4. Also, is there a workaround where where we do not need to load the quartile table? 

[Greg_Deckler]

@Brainfried88 So like this: (2) QUARTILE - Microsoft Power BI Community ?