0 votes
1 view
in BI by (17.6k points)

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.

ScoreUrl

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.

Relations

 

1 Answer

0 votes
by (47.2k points)
  • Make use of LOOKUPVALUE :

  • Use the following MEASURE:

RoundedUpAverageURL = LOOKUPVALUE ( Smileys_Sheet[Url], Smileys_Sheet[Score], [RoundedUpAverageScore] )

Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...