topic Re: Count Unique Rows in Desktop

Count Unique Rows

BarryFletcher — Mon, 16 Dec 2024 14:49:56 GMT

Trying again with this one - my rushed typing wasn't clear the first time - apologies.

I have a list of timesheets whish are entered weekly, as can be seen on the image below, each entryin each timesheet is listed, showing 5 items. what i would like to do is just count the number of timesheets submitted and nt each entry - so 3 timesheets entered.

So for "Liz" can I get a record / count to say one entry and use that as a timesheet submitted "count".

So week 45, Liz submitted 1 timsheet and the fact the there are 2 entries on that timesheet is irrelevant to me.

The overall result for week 45 is that 3 timesheets were submitted.

Re: Count Unique Rows

HotChilli — Fri, 13 Dec 2024 11:14:27 GMT

15 is the rows for this Staff Name - is that right?

"The result of my count should say list 7 ites" - typo? what does this mean?

Re: Count Unique Rows

BarryFletcher — Fri, 13 Dec 2024 11:18:45 GMT

Typoe - apologies. Should say Rows.

Re: Count Unique Rows

HotChilli — Fri, 13 Dec 2024 11:22:02 GMT

Thanks.

Where does the 7 come from? It says "5 timesheets" in the post above.

"submitted 5 timesheets but they contain 15 individual items. The result of my count should say list 7 rows rather than 15?"

Re: Count Unique Rows

BarryFletcher — Fri, 13 Dec 2024 11:26:25 GMT

Sorry - my bad again - am working an typing...

It should be "8" - I am trying to count how many timesheet were submitted so if you look at the work weeks (45 - 52) I'd like the count to be "8" timesheets taken from the 15 rows

Re: Count Unique Rows

HotChilli — Fri, 13 Dec 2024 16:09:54 GMT

distinctcount of week#

Re: Count Unique Rows

BarryFletcher — Fri, 13 Dec 2024 17:48:56 GMT

Thank you for replying with suggestions but I think I am not clear on what I am looking for....

Based on the table below, as you can see 3 people have entered time for week 45 (and other weeks) - is there a way I can get da to look at this table and tell me 3 people have netered time and not count the 2 entries by Allan and Bokic?

So from the table below there are 5 entries but I would like to just count that each person has submitted one timesheet?

What I am trying to achieve is being able to tell our Pc team that 3 timesheets have been submitted from the data provided knowing the Allan and Bokic submitted one timesheet with 2 charge codes

Re: Count Unique Rows

danextian — Sat, 14 Dec 2024 15:40:33 GMT

Hi @BarryFletcher

The unique count should be based on what columns? - So if these columns were to be combined together, they'd be considered a count.

Re: Count Unique Rows

danextian — Sat, 14 Dec 2024 15:40:55 GMT

Would be better if you just edited your post to make it clearer.

Re: Count Unique Rows

Anonymous — Tue, 17 Dec 2024 07:36:32 GMT

Hi @BarryFletcher ,

This is my test data.

We can create a new table.

Table 2 = SUMMARIZE('Table',[Staff Name],[#Week],"work_hours",SUM('Table'[Work Hours]))

If I have misinterpreted your needs, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

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

Re: Count Unique Rows

BarryFletcher — Tue, 17 Dec 2024 07:43:40 GMT

Thank you very much for the help Neeko, worked perfectly.

Barry