Forum Discussion

BTI_Afuentes's avatar
BTI_Afuentes
Helper I
6 years ago
Solved

Select data based on range values from a realated table

Hi everybody.   I have a summarized table where it is calculated a Score for a project. This table is related to a 'Scale' table where I have several ranges for identify the grade based on the scor...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Perhaps:

 

 

Scale Result Column =
  VAR __Score = 'Project'[Score]
  VAR __ID = 'Project'[ScaleID]
  VAR __Scale = 
    MAXX(
      FILTER(
        'Scales',
        'Scales'[ScaleID] = __ID &&
          'Scales'[From] <= __Score &&
            'Scales'[To] >= __Score
      ),
      [Scale Result]
    )
RETURN
  __Scale