Data repeats not showing in table with certain filters

[PowerAutomater]

I have a simple set of data looking at events people have gone to from different teams:

Name	Even	Team	Due Date
John Smith	Interesting Event	1	1/1/1
John Smith	Not Really Interesting Event	1	2/1/1
Jill Smith	Great Event	1	1/2/1
Jimmy SMith	Great Event	2	1/2/1
Jenny Smith	Great Event	2	1/2/1
Jenny Smith	Horrid Event	2	3/2/1

I have used a table visual but I find for some reason when filtering by teams, some teams show all the repeats (eg. John Smith & Jenny Smith above) but some only show one event per name. So using the above data as an example, filtering by Team 1 shows only 2 events (John & Jill), while filtering by Team 2 shows all 3 events. I have gone as far as copying and pasting the table that was showing the repeats (to make sure there wasn't any setting differences) but the moment I switch the filter to the other team it goes back to only the distinct results and I cannot work out why. I have all of the fields set to "Don't Summarise" (not count distinct), except for the date field of course, I've been through the formating tabs and at this point I'm really not sure what other setting to check. Any ideas what could be causing this?

[danextian]

Hi @PowerAutomater 

It seems that you're  trying to show all rows regardless of whether they contain the same value sor not. If that is the case, that behaviour of the table visual is to be expected - it summarizes the data. Unless you add another column that distinguishes each record (an index or id column unique to each row), all those other columns with repeating values will be summarized. If this isn't the case, please show the expected result (not just the description) using the same sample data.

[PowerAutomater]

Sure so when the data is not filtered by any Team it should be:

Name	Event	Team	Due Date
John Smith	Interesting Event	1	1/1/1
John Smith	Not Really Interesting Event	1	2/1/1
Jill Smith	Great Event	1	1/2/1
Jimmy Smith	Great Event	2	1/2/1
Jenny Smith	Great Event	2	1/2/1
Jenny Smith	Horrid Event	2	3/2/1

When it is filtered to show only Team 1 it should be:

Name	Event	Team	Due Date
John Smith	Interesting Event	1	1/1/1
John Smith	Not Really Interesting Event	1	2/1/1
Jill Smith	Great Event	1	1/2/1

And when it is filtered to show only Team 2 it should be:

Name	Event	Team	Due Date
Jimmy Smith	Great Event	2	1/2/1
Jenny Smith	Great Event	2	1/2/1
Jenny Smith	Horrid Event	2	3/2/1

What is actually happening is that when filtering by some teams only one event per name shows (removing any duplicates) not showing the full data:

Name	Even	Team	Due Date
John Smith	Interesting Event	1	1/1/1
Jill Smith	Great Event	1	1/2/1

While other teams still show correctly all events per name:

Name	Even	Team	Due Date
Jimmy Smith	Great Event	2	1/2/1
Jenny Smith	Great Event	2	1/2/1
Jenny Smith	Horrid Event	2	3/2/1

Now the above is obviously just example data for illustrating the issue, the real data (which I can't include) has more Teams, more Events, Names etc. So my question is why does filtering by some teams show everything correctly (eg. how Team 2 does above) but others do not (eg. how Team 1 does) when the filters and fields are the same for both visuals, to the extent that I've copied and pasted the visual but the moment I change to a filter to a certain team only one event per name appears. And in the raw data I can clearly see there are multiple events per name. Hopefully this makes sense.

If I instead show this same information as a total row count in a data card, the correct total (with multiple events per name) shows when using count (eg. 3 for Team 1), while the incorrect total (with one event per name) shows when using distinct count (eg. 2 for Team 1). It's as if in the table visual a distinct count has been set somewhere even though as mentioned I've already checked and all fields (except date) are set to don't summarise. It's probably hard to replicate since as I said I can't work out why it only happens for some teams and not others and what setting is creating the difference.

[Ashish_Mathur]

With the sample data that you have shared there, is absolutely no problem at all.  Difficult to suggest anything unless you share the section of data where you are facing a problem.

[PowerAutomater]

Yes it's very strange, I can't share the actual data unfortunately, but is there any setting in the format tab for example or elsewhere that could be reposnsible for displaying this data in this way that I can try to adjust? Really not sure where to look at this point

[Ashish_Mathur]

Hi,

Based on the table that you have selected, show the expected result very clearly.

[PowerAutomater]

Please see my reply above

[ryan_mayu]

@PowerAutomater 

I think that is by design. If you only display name, then no need to display duplicated names. that's meaningless.

You can add more columns (e.g. date column or event column) to see the duplicated names

or you can create a measure to count  rows. Then the total number will be 3.

[PowerAutomater]

I actually already have all of the additional columns in the table (as per the table in my question), it is just that literally when I change the filter to show only Team 1 data vs Team 2 one shows everything including the repeats and the other only shows one row per name even if there are multiple events per name. It's really bizarre and I can't work out why