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

hi jdormer

 

create this measure:

 

SalesPerson = CALCULATE(VALUES(Users[Name]);FILTER(Managers;Managers[Allocation ID]=1))

 

Project Manager = CALCULATE(VALUES(Users[Name]);FILTER(Managers;Managers[Allocation ID]=2))

 

Architect = CALCULATE(VALUES(Users[Name]);FILTER(Managers;Managers[Allocation ID]=3))

 

 

  • 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.