Forum Discussion

aaron1225's avatar
aaron1225
Helper I
8 years ago
Solved

Related Function Help

Normally I can work with RELATED but in this instance I can not get what I need.  Basically trying to compare two tables identify if what the overlap is.   Senerio:  have a table with opportunities...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    aaron1225

     

    Try this calculated column

     

    Column In OneSideTable =
CALCULATE ( FIRSTNONBLANK ( ManySideTable[TEXT Column], 1 ) )
Anonymous's avatar
Anonymous
Not applicable
8 years ago

The Related Function can't pull in on the Opportunities table beacuse, RELATED fails to figure out which row value has to bring in as it was supllied with mutliple rows (many side relationship have mutliple rows for a given row in one side).

 

In order to deal with multiple rows we have to use RELATEDTABLE instead of RELATED and then you can aggregate on multiple rows to bring in one value for each row in Opportunities table.

 

RELATED is used in many side of a relationship in (* : 1)

RELATEDTABLE is used in one side of a relationship in (1 : * )

  • aaron1225's avatar
    aaron1225
    Helper I
    8 years ago

    Thank you for the help, what if I need to pull in a TEXT value?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      On what bases do you need to pull the Text value as you are supplying many text values in to the Function. We need a condition to sort out one text value out of multiple values supplied.

      • Zubair_Muhammad's avatar
        Zubair_Muhammad
        Community Champion
        8 years ago

        aaron1225

         

        Try this calculated column

         

        Column In OneSideTable =
CALCULATE ( FIRSTNONBLANK ( ManySideTable[TEXT Column], 1 ) )