Get employee names from a count of employees

[ferk_]

Hi,

For now I have this formula (Measure):

#Work Hours = CALCULATE(COUNTA(Employees[ID]),filter(Employees,Employees[WorkHours]>45))

This is returning the number of employees that worked more than 45 hours. I need to return the list of employees (name) that worked more than 45 hours in a visual (can you suggest me something) like Table or Card. I have the column Name in the Employees table. 

Any help/tip is welcome. If you need more information/clarification tell me.

Thank you,
Ferk

[ferk_ · Accepted solution]

Thank you for your answers @v-jianpeng-msft and @jeewats!

I found this solution:

Employees =

CONCATENATEX(

            FILTER(

                Employees,

                Employees[WorkHours] > 45 

            ),

            Employees[Name],

            " , "

    )

[v-jianpeng-msft]

Hi, @ferk_ 

I'm happy to answer your questions. I suggest using the following method to filter the Work Hours>45 employee rows, which is very easy to do. I created a sample with the main data as follows:

Let's create a table visualization:

We set the Work Hours in the filters >> show items when then values >> is greater than >> Enter 45 in the input box below >> Apply filter

Here are the results:

The second way, we can create a slicer as follows:

Move the slider to 45:

This also allows filtering to be achieved. If the above solutions can help you, that's great. I've provided my sample PBIX file below.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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

[jeewats]

One easy thing you could do is wrap that in an IF statement and create two categories, those that work > 45 hours and those that don't. Then create a table with all employee names and use that measure as a filter on the table. That should only show those that worked greater than 45 hours. There are probably more elegant ways to do it, but that's the quick, dirty way I'd do it.