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
jdormer's avatar
jdormer
Helper I
10 years ago

Thanks Vvelarde.

 

When I create the measures you suggest and then add them to a visual, I get a "Can't display the visual." error message. The detailed message states "Calculation error in measure Managers[Architect]: A table of multiple values was supplied where a single value was expected. 

 

 

Thoughts?

Vvelarde's avatar
Vvelarde
Community Champion
10 years ago

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

 

 

 

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    10 years ago

    If you have more than 1 same allocation for a Project then this measure doesn't work.

  • 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