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.

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