Merge Tables & Counts

[sdhn]

Hello All,

I have 5 source files on same folder.

I used Get Data -- Folder options to merge all files onto one file called Source. 

I need to counts rows for each file.

 Following measure counts all rows togather  (Count all 5 files rows):

Source Counts  = COUNTROWS(ALLSELECTED('Source'))-1

I want to counts rows for each file.

OMP 40

ABC 8

XYZ 10

AEIOU 22

I have follwing sample columns

Source.Name	Service	Esclation Team	Created	Owner
OMP	Telephone	test	01/01/2022	AB
ABC	911	test1	12/01/2021	CD
XYZ	211	FF	01/02/2022	YZ
AEIOU	007	Pol	12/31/2021	UV

 help will be appreciated.  Thanks 

[smpa01]

@sdhn  try this

measure = CALCULATE(COUNT(tbl[Source.Name]),ALLEXCEPT(tbl,tbl[Source.Name]))

[sdhn]

measure = CALCULATE(COUNT(tbl[Source.Name]),ALLEXCEPT(tbl,tbl[Source.Name]))

Source.Name is the column name. It is giving me a total row counts of all files. I want each file separately.   Thanks 

[smpa01 · Accepted solution]

@sdhn  if i have a table like this

The above measure gives me this

[sdhn]

Actuall I got it. I need to click new measue and source.name.  Thank You 

[sdhn]

Source.Name column has been created when I merged (transform & load)  files onto one file. Probably becasue of this.  This column was not a part of a files ealier.  Under the source.name col. I have all 5 files names listed with extension.   any thoughts

[smpa01]

@sdhn  provide a sample pbix, hard to guess from words.