Forum Discussion

Beth_H's avatar
Beth_H
Frequent Visitor
2 years ago

Calculated Column that might pull multiple values

Hi there,   I am trying to create a table which pools information from another table but orders in a different way.   Below is the UserFieldValue table.    UserFieldValue       RecordI...
HotChilli's avatar
HotChilli
Community Champion
2 years ago

selectedvalue is going to return the "Multiple Input" if the UserFieldValue[All_UserFieldValue] is blank OR there are multiple values so this may require more work.

However, the main problem is that the RecordID is not passed to the FILTER statement so it will be looking for userfieldid = 855 without the specific ID.  So you can probably  just add that in to the search clauses (&& UserFieldValue[RecordID] = thisTable[RecordID] )

 

--

Also the column seems to have 2 different names (value or All_userFieldValue)

  • Beth_H's avatar
    Beth_H
    Frequent Visitor
    2 years ago

    The different value names are because I was simplifying the data for the sake of this post and missed an alteration..

    But you're quite right! The FILTER did need specification on the recordid, have since adjusted:

     

     

    Agency = CALCULATE(
        SELECTEDVALUE(UserFieldValue[Value]),
        FILTER(UserFieldValue, UserFieldValue[RecordId]='Custom Field Reporting'[Id] && UserFieldValue[UserFieldId]=855)
    )
     
    However still faced with the issue that when an ID has multiple input values, the SELECTEDVALUE returns a blank