Calculate measure with unique value from another table

[Mac2]

Hi,

I have a measure that I am using in a matrix as show below:

           HT1    HT2 HT3 HT4 HT5

A         32      34    30     31  33

B         30      31    33     32   31

C        28      25     29    32    30 

I have another table

Term  Days

HT1    34 

HT2    39 

HT3    33 

HT4    35

HT5    36

I am trying to write a measure that perform a division eg

           HT1        HT2        HT3       HT4      HT5

A         32/34      34/39    30/33    31/35   33/36

B         30/34      31/39    33/33    32/35    31/36

C        28/34      25 /39    29/33    32/35     30/36 

How can I write this measures? I also need to multiply these number by 100 to work out the percentage. 

Thanks in Advance

Mac2

[Mac2]

Thank you so much for your help. Much appricated! 😊

[FreemanZ · Accepted solution]

hi @Mac2 

try like:

Measure2=
VAR _days =
MINX(
    FILTER(
        ALL(AnotherTable),
        AnotherTable[Term] = MAX(Table1[Term])
    ),
    AnotherTable[Days]
)
RETURN
DIVIDE([measure], _days)