In Power BI I have a measure that calculates the average value of a column. It always contains a number between 0 and 4
RoundedUpAverageScore = ROUND(AVERAGE(SmileyHistory[SatisfactionLevel]),0)
I then have a table that consists of a score from 0 to 4 and a URL.
I want to use the RoundedUpAverageScore to look up which URL to use for an image in Power Bi.
Naturally, I cannot make a relation between a measure and a column in Power Bi, so the two tables are currently not connected.