Calculating the average of two columns (that calculate percentages)

[crmart1n_mx]

I have two columns in PowerBI whos values are percentages. What i'm trying to achieve is to via a measure (which I intend to use in a visual within a report/dashboard), calculate the average of the first column (GO_Disp[WrapCodeAdherance]), then the average of the second column (UP_Disp[WrapCodeAdherance]), and then calculate the average of both of those results.

Both of these column appear on different tables.

First Table: GO_Disp[WrapCodeAdherance]

Second Table: UP_Disp[WrapCodeAdherance]

How would I calculate this?

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.