Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Getting values from average values based on criteria

Hello, i have 2 tables loaded in the data model. The first table shows the historical values based on certain cities or location.    City Country Continent Value New York US North Americ...
kentyler's avatar
kentyler
Solution Sage
6 years ago

if ISBLANK([average for city]),
      if(ISBLANK([average for country]),
              [average for continent]),
      [average for country]),
[average for city])

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for the feedback, the measure below will be placed in the second table? should i establish a relationship between two table?