How to combine two data

[Rio26]

How to combine two data to get the total average value of both data,

Please help ...

[johnyip]

Given your information, a possible answer is to use PowerQuery or SQL to union your data, and then create a measure to calculate the average.

You can provide some more info like where are the data sourced from, the structure of it, what column(s) do you want to get the average from, etc, for a more specific solution.

[Rio26]

Output must be average 111.7%

I've tried measure combining both data but the result is not right

Can u help me?

[ryan_mayu]

could you pls provide the sample data and expected output?

[Rio26]

Output must be average 111.7%

I've tried measure combining both data but the result is not right

Can u help me?