Forum Discussion

Tomhayw's avatar
Tomhayw
Icon for Helper I rankHelper I
3 years ago
Solved

Summing a dynamic measure

Hi there,   I'm having trouble with one of my measures: I have this table of utilisation rates. The 'Fact' column is just a sum of days worked by an employee. The 'Target' column is the tot...
Need Help
  • Tomhayw's avatar
    Tomhayw
    3 years ago

    I've figured it out:

     

    I used =SUMX(VALUES( Target, username)

     

    to allow me to sum all the different rows together.

Tomhayw's avatar
Tomhayw
Icon for Helper I rankHelper I
3 years ago

I've figured it out:

 

I used =SUMX(VALUES( Target, username)

 

to allow me to sum all the different rows together.