LookML - filter measure by the dimension in another view

Context:

  • View 1: Fact Sales
    • Dimension:
      • Date
    • Measure:
      • Total Sales
  • View 2: Dim Calendar
    • Dimension:
      • Date
      • Year

Question:

given the above two views which in Explore are combined via join, how can I define the following Measure in the View (LookML): Total Sales filtered by ‘Dim Calendar’[Year = 2020].

This needs to be a new measure that exists within the View definition.

Thank you,

Enrico

Solved Solved
0 3 2,274
1 ACCEPTED SOLUTION

3 REPLIES 3
Top Labels in this Space
Top Solution Authors