Line chart based on 3 or more tables

[MasterSonic]

Hi guys

I have one table with some  measurement:

Total = DIVIDE(CALCULATE(COUNT('Table1'[Number])*112),DISTINCTCOUNT('Table1'[Attribute]))

 I copy Table1 to get Table2 and change sharepoint file and table 3 ect.

Now I would like to put results of 
Total 1 = DIVIDE(CALCULATE(COUNT('Table1'[Number])*112),DISTINCTCOUNT('Table1'[Attribute]))
Total 2 = DIVIDE(CALCULATE(COUNT('Table2'[Number])*112),DISTINCTCOUNT('Table2'[Attribute]))
Total 3= DIVIDE(CALCULATE(COUNT('Table3'[Number])*112),DISTINCTCOUNT('Table3'[Attribute]))
on line chart for each Table.

There is no calendar table or there are no any dates in my tables .
( I can add some date column for each table to get X-axis if that will help ?)

Any advice please?

[daXtreme]

First, I can't see a reason to maintain 3 different tables with the same layout. Waste of time and effort. Just consolidate them into one, maybe adding a column that will indicate which table the row comes from. Second, isn't it easy to add 3 different lines to a chart based on 3 different measures? I thought this would be easy-peasy...

[MasterSonic]

Alway good to listen  wise people.😎 I added date columns for each table and date table.

1.What this consolidation would be about ? any link ? 
2. How to create lines between these 3 measurments ?

[daXtreme]

Consolidation? Well, it's just creating one table out of 3. Nothing more. In Power Query that's a cinch. One click of a button. As for the second one... Maybe you should change the style of the line? Maybe you should change the axis type to continuous/categorical? Experiment 🙂 If you want to see with your own eyes how to do things in Power Query, well, then YouTube is your best friend. And, of course, its Search Box.

[MasterSonic]

I did check lines stule, axis types too, someone here had same problem with datamismatch as a reason, I did check it too

I snipped Table view, should not this total points(measurments) be one under another to show lines ?