Forum Discussion

Icon for Responsive Resident rank

Responsive Resident

4 years ago

Solved

Merge Tables & Counts

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

Help appreciated

smpa01
4 years ago
sdhn if i have a table like this

The above measure gives me this

6 Replies

smpa01
Community Champion
4 years ago
sdhn try this

measure = CALCULATE(COUNT(tbl[Source.Name]),ALLEXCEPT(tbl,tbl[Source.Name]))
- sdhn
  Responsive Resident
  4 years ago
  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
    Community Champion
    4 years ago
    sdhn if i have a table like this
    
    The above measure gives me this