How to add a constant target across time - Matrix

[aboileau]

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 to reside where it says exam shifts by location. There is no time on this table as I want it constant throughout time.

[Abhinav054 · Accepted solution]

Ok, then create a Constant Measure 

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

[aboileau]

Amazing Thank you so much!!!

[Abhinav054]

hii, once try this

1. Create a new row in your matrix and label it "Target."
2. In the "Target" row, enter the constant value that you want to use to track exams relative to.
3. To calculate the relative difference between the actual number of exams and the target, use the following formula:
   

   Relative difference = (Actual number of exams - Target) / Target

1. Enter the relative difference values into the "Exam Shifts" column for each location.

[aboileau]

Hi! Thank you.

So what I'm looking for in the first table is my constants (1 target for each location that holds true across weeks) as I have multiple locations and multiple targets. That table is connected via my Location Name.

I'm trying to get a measure that has the constant appear each week across all weeks given there is no date on that table.