Forum Discussion

aboileau's avatar
aboileau
Frequent Visitor
2 years ago
Solved

How to add a constant target across time - Matrix

Hi All!   I'm trying to make a target row in my matrix to track exams relative to this target that is constant throughout time. I made a table where the constants are located. I want them t...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Ok, then create a Constant Measure 

    Constant = VAR LocationName = MAX(Table1[Location Name])
    RETURN Table2[Target]