Average value from second table

[Mbechet]

Dear All,

I am sure my question is very basic.

I have 2 tables:

- PreviousMonth, in which i get the hours and amount for each persons (1 line per date)

- ThisMonth, in which I get the hours done in the current month by person (1 line per date)

I have created a third table to get the unique ID of each person and link both tables together through this third one

I just want to calculate in the Table ThisMonth the average amount per hour for PreviousMonth.

I am using the below measure but I miss something as it gives me the total average independently of the ID of the person.

I have tried to merged the tables but I have too many rows on my actual data and it is taking hours to refresh.

Thank you all very much in advance for your help.

[fhill · Accepted solution]

Make sure your Relationships are set to BOTH for 'Cross Filter Direction' since you are passing thru the ID table to get data from another table.  Also, I tried this less complex Measure allowing ID to be calculated based on the table values instead of forcing the filter (but I think your code works as well).

FOrrest

[Mbechet]

Wonderful,

I was sure it was simple! The only issue was the both directions from my tables relationships.

Thank you very much and have a great weekend!

[Vvelarde]

@Mbechet

Hi, The ID in your visual This Month is from ID Table?.

If answer is no try using this.

Regards

Victor

Lima Peru