Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |