Finding the common item in 'similar' data sources

[JediMole]

I'm creating reports from 7 different client portals, each in their own standalone instance in azure.  A large part of it is event type data, hotels, attendance stats, venue locations and some budgetary items.  I wanted to create a venue report to show how attendance was, and which location seemed to favor hosting attendees, meaning who was used most often and the attendees invited compared to those that actually attended.  Normally the common item would be the Event ID, but to my dismay, the event id is a sequential number that starts the same sequence in each portal.  Meaning there's a good chance the numbers will be the same at some point in each portal export.

So my question is, how can I bring all the files into one report and still be able to use an Event ID count as a common column.  Can I replace the 'event id' with a sequential count because I don't need to drill into the event specifics and achieve the result I'm looking for?

1. Bring all the files into power BI as a folder
2. Transform the data and kill the event id column and replace it with a count column

Recreate the report below with the combined data:

[vojtechsima]

Hello, @JediMole ,
if you don't need event specifics, I would just put all all events together, you can ignore the Event ID and for the the Count of Events, just use regular:

COUNTROWS('EventTable')

Because you will know, that one event = one row.

[JediMole]

Is my idea of pulling the files in from a single folder sound?  I tried that once and it worked as it appended the file name for each different file in the first column.

Can you show me how that countrows looks?  is it just a new column or?

[vojtechsima · Accepted solution]

Well, @JediMole 
I am not sure what will be your source, but I recommend Sharepoint Folder if you have flat files.

Then when you append them all together, can look like this:

This then the measure you will use, it's not a column.

[JediMole]

Ohhh I see that now, interesting