Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create a table from the source data

Hi Need help in creating a dynamic table out of the employee source data based on a particular column which has names of team leads (includes duplicates). This new table should count the ranks (text...
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    Anonymous 

    Okay, this is what you are looking for I think:

    Employee Rank % = 
DIVIDE(
    COUNT(Employee[Employee]),
    CALCULATE(
        COUNT(Employee[Employee]),
        ALLSELECTED(Employee[Rank])
    ) 
)

     

    If you are satisfied with my answer, please mark it as a solution so others can easily find it.

    APPRECIATE KUDOS!



  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

     

    Select the column/measure you want to modify, then you will find "%" in menu bar.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Fowmy's avatar
Fowmy
Super User
6 years ago

Anonymous 

Do you need to have a table created in the format you need or are you trying to show in it in a visual in the same layout?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

No, thats how my output visual should be, however i need to further calculate the % of the ranks of each TLs based on the employee strength

  • Fowmy's avatar
    Fowmy
    Super User
    6 years ago

    Anonymous 

    Then you simply use a MATRIX visual and plot your fields as I did below.

    If you are satisfied with my answer, please mark it as a solution so others can easily find it.

    APPRECIATE KUDOS!

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi

      Its not quite what i want, although it sort of in the same directio. i want the unique Team Leads in column 1 instead of the employees and rest of the columns to give the % of count of a particular rank divided by the total number of employees of that particular team lead

      • Fowmy's avatar
        Fowmy
        Super User
        6 years ago

        Anonymous 

        Okay, this is what you are looking for I think:

        Employee Rank % = 
DIVIDE(
    COUNT(Employee[Employee]),
    CALCULATE(
        COUNT(Employee[Employee]),
        ALLSELECTED(Employee[Rank])
    ) 
)

         

        If you are satisfied with my answer, please mark it as a solution so others can easily find it.

        APPRECIATE KUDOS!