Use a measure of a table in another table

[Anonymous]

Hi ! 

This is my problem I have these 2 graphs : 

You can see that the 2 graphs are same, just the intern production percentage (in black) is different because I use 2 different database to do the graphs, the total production is the same but the split Intern production and non intern production is different

So I want to keep just one graph and put the 2 percentage curve in the same graph but when I do this this is the result

The orange curve is not good...

This data is like this : (direct = intern production, toller = non intern production)

And I the intern production is obtained by a measure : 

InterProductionPercentage = CALCULATE(SUM('Data'[Value]), 'Data'[Category]="Drying Direct")/(CALCULATE(SUM('Data'[Value]),'Data'[Category]=="Drying Toller")+(CALCULATE(SUM('Data'[Value]),'Data'[Category]=="Drying Direct")))

I made this measure for the 2 database but when I move one mease in an other graph (from the other data) I don't have the good curve

Do you have a solution to solve this ? Thanks in advance

[Anonymous]

Hi @Anonymous ,

Glad to know your issue has been resolved!

Could you please Accept your last reply as the solution to make the thread closed?  The other members find it more quickly😀

Best Regards,
Eyelyn Qin

[PaulDBrown]

Please provide sample data or a PBIX file

[Anonymous · Accepted solution]

I solve the problem thanks for your help

If someone is interested the solution is create a relation between the two tables with the "Year" column

[Anonymous]

Hello,

Can you please explain more? I think you have a problem in your model that the two tables don't have a connexion between them? 

[Anonymous]

Yes sorry it's not clear

I have 2 differents tables which represente the production (intern or non-intern) of some countries each year between 2021 and 2026

The total production (intern + non intern) is the same for the two tables

Just the split Intern-Non Intern production is different so the percentage curve (in black) is different if you look the 2 graphs

So I want to keep just one graph and add the percentage of intern production of the other table but when I did this I don't have the good curve. I think your are right I have to have a relation between the tables ?