Forum Discussion

BTI_Afuentes's avatar
BTI_Afuentes
Icon for Helper I rankHelper 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
Icon for Community Champion rankCommunity 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

 

  • BTI_Afuentes's avatar
    BTI_Afuentes
    Icon for Helper I rankHelper I
    6 years ago

    Thank you very much Gerg! 

     

    It worked when I used the DAX from the solution on the Quick Measures gallery. 

     

    Regards,

    Angel