Sorting through a Table of Information

[RobKay12]

Hello,

You have been very helpful in the past and I have another one for you that I think is over my head. I have the following table:

Job #NameDate

The Data I Have
2103612	Doe, John	2/12/2024
2103612	Doe, John	2/13/2024
2103612	Doe, John	2/14/2024
2103612	Doe, John	2/12/2024
2103612	Doe, John	2/13/2024
2103612	Doe, John	2/12/2024
2103612	Doe, John	2/13/2024
2103612	Doe, John	2/14/2024
2103612	Doe, John	2/14/2024
2103612	Doe, John	2/12/2024
2103612	Doe, John	2/13/2024
2103612	Doe, John	2/14/2024
2203434	Smith, Jane	2/15/2024
2203434	Smith, Jane	2/15/2024
2303429	Smith, Jane	2/12/2024
2303429	Smith, Jane	2/13/2024
2303429	Smith, Jane	2/14/2024
2303602	Parker, Peter	2/12/2024
2303602	Parker, Peter	2/13/2024
2303602	Parker, Peter	2/14/2024
2303602	Parker, Peter	2/15/2024
2303612	Parker, Peter	2/12/2024
2303612	Parker, Peter	2/13/2024
2303612	Parker, Peter	2/14/2024
2303612	Parker, Peter	2/15/2024
2303612	Parker, Peter	2/12/2024
2303612	Parker, Peter	2/13/2024
2303612	Parker, Peter	2/14/2024
2303612	Parker, Peter	2/15/2024

And I need to show:

What I need to Know
John Doe	3
Jane Smith	4
Peter Parker	4

Basically, The employee has to have 1 meeting for every different job # and every different date, if that makes sense. If the name is attached to the same job number on the same date then it only counts as 1.

Any help is greatly appreciated.

Thank you

[RobKay12]

I think I am off the track a bit, try this example (notice the similarity in spelling of the names but I can't get any fuzzy functions to work as I need). I have the following information:

And I want to see the following results:

Thank you all.

[v-yaningy-msft]

Hi, @RobKay12 

Based on your description, you want to implement filtering of sold games. I have created two methods to achieve the effect you are looking for. Following picture shows the effect of the display.

Method 1:

DAX:

Table 1 =

SUMMARIZE(

    'Table',

    'Table'[Name],

    "counts", DISTINCTCOUNT('Table'[Date])

)

Method 2:
Measure:

Counts = DISTINCTCOUNT('Table'[Date])

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Daoud_H]

Hi @RobKay12 , 

You can try to create a table with a DAX measure : 

Table = 
SUMMARIZE(
    'Table', 
    'Table'[ID], 
    'Table'[Name], 
    "Count", DISTINCTCOUNT('Table'[Date])
)

[audreygerred]

Hello! You can create a concatenation column in Power Query by creating a custom column combining the Job #, Name, and Date. Once the data loads in Power BI, create a measure for the DISTINCTCOUNTNOBLANK of your new column. Make sure you have an employee dimension table. For your visual, grab teh name of employee from your dim table and the measure.

[RobKay12]

Thanks. I tried this but it keeps giving me errors from the data.

[audreygerred]

What is the error that you are getting? You probably have to make the job number and date fields be strings first to concatenate. Then after the concatenation step (custom column) is applied, put the fields back to the proper data type.