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
Icon for Solution Sage rankSolution Sage
6 years ago

Write 3 helper measures:

Average for City

Average for Country

Average for Continent

Since measures can refer to other measures then you can write a measure that does your if logic to see which average is present for a given combination

  • kentyler's avatar
    kentyler
    Icon for Solution Sage rankSolution 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?