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 

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!



    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      this is perfect! how do i convert the values to %?

      • Icey's avatar
        Icey
        Community Support
        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.