Grouping data to identify and show conflicts

[PhotoRonin]

I have a data set that I'm trying to evaluate, but can't figure out how to get the results that I know are there!  I have a CSV data set of a listing of files in directories in different domains, as an example:

NetLogonPath	Name	Size	Domain	FullName	CreatedOn	ModifiedOn
temp.cmd	temp.cmd	24	something.com	\\something.com\NETLOGON\temp.cmd	date	date
temp.cmd	temp.cmd	24	test.something.com	\\test.something.com\NETLOGON\temp.cmd	date	date
Scripts\what.bat	what.bat	243234234	something.com	\\something.com\NETLOGON\Scripts\what.bat	date	date
Scripts\what.bat	what.bat	243234234	test.something.com	\\test.something.com\NETLOGON\Scripts\what.bat	date	date
Scripts\what.bat	what.bat	164000	huh.something.com	\\huh.something.com\NETLOGON\Scripts\what.bat	date	date
Scripts\what.bat	what.bat	243234234	poo.something.com	\\poo.something.com\NETLOGON\Scripts\what.bat	date	date

What I want to see out of this data is something like:

NetLogonPath	Instances	Size	Domains
temp.cmd	2	24	something.com, test.something.com
Scripts\what.bat	3	243234234	something.com, test.something.com, poo.something.com
Scripts\what.bat	1	164000	huh.something.com

Based on above, I'd like the "NetLogonPath", size, and number of instances of each item that has the same "NetlogonPath" and "Size", and consolidating the "domain" fields into a single result.

[v-yuezhe-msft · Accepted solution]

@PhotoRonin,

Create the following measures in your table.

Instances = COUNTA(Table[Name])
Domains = CONCATENATEX (VALUES(Table[Domain]), Table[Domain], ", ")

Then create the table visual as follows, make sure that you choose “Don’t summarize” for Size.

Regards,
Lydia