Forum Discussion

jdormer's avatar
jdormer
Helper I
10 years ago

Engagement Role Report - Calculated Column question

I am having some difficulty creating a measure to display the individuals working on an engagement and their roles. I have the following tables:       The managers table lists Managers for ea...
Need Help
Vvelarde's avatar
Vvelarde
Community Champion
10 years ago

And this happen with the other measures also? or just with Architect?

 

 

 

jdormer's avatar
jdormer
Helper I
10 years ago

Vvelarde, I get the same error for all three measures. 

 

EDIT: There are some Engagements that do have duplicate Allocation IDs. 

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    10 years ago

    Ok, this is a different situation. The posted measures work only when its a unique allocation id by project.

     

    Now, with this duplicates rows, how do you want to visualize?

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      10 years ago

      jdormer

       

      a Ugly solution is create column calculated for earch allocation:

       

      SalesPerson-Col = if(Managers[Allocation ID]=1;RELATED(Users[Name]);BLANK())

       and repeat with others allocation

       

      Now put in a matrix visual

    • jdormer's avatar
      jdormer
      Helper I
      10 years ago

      Ideally, I would be able to display the name of both/all salespersons, Project Managers, and Architects in a single row.