Forum Discussion
sdhn
Responsive Resident
Responsive ResidentMerge 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 measur...
smpa01
Community Champion
Community Championsdhn try this
measure = CALCULATE(COUNT(tbl[Source.Name]),ALLEXCEPT(tbl,tbl[Source.Name]))sdhnResponsive Resident
Responsive Residentmeasure = 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
- 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
- sdhn
Actuall I got it. I need to click new measue and source.name. Thank You