Forum Discussion

Mbechet's avatar
Mbechet
Frequent Visitor
9 years ago
Solved

Average value from second table

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 ...
Need Help
  • fhill's avatar
    fhill
    9 years ago

    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

     

     

     

     

     

     

fhill's avatar
fhill
Resident Rockstar
9 years ago

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's avatar
    Mbechet
    Frequent Visitor
    9 years ago

    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!