Forum Discussion

N_R_000's avatar
N_R_000
Icon for Helper I rankHelper I
4 years ago
Solved

DAX Totals not matching values

I know this one has been asked before, but I can't find a solution that fits my issue.    Imagine 3 tables:  A date table A Users table - single row per user, with a Productivity Target per user....
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    Rename your current measure to be Individual Target then create a new measure

    Target = IF ( ISINSCOPE(Users[User ID]), [Individual Target],
var summaryTable = ADDCOLUMNS( SUMMARIZE( Users, Users[User ID]), 
"@val", [Individual Target])
return SUMX( summaryTable, [@val])
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi N_R_000 ,

 

If your issue has already been resolved, please mark the helpful replie as solution, more people will benefit.😁

 

Best Regards,
Stephen Tao