Forum Discussion

PBI5851's avatar
PBI5851
Helper V
4 years ago
Solved

Adding Targets to Matrix

Hello, Please can you help me in adding target to the matrix. I tried to add a measure as Target =2 and it works for individual records but it does not sum and in the total it shows as 2 rather than...
Need Help
  • HoangHugo's avatar
    HoangHugo
    4 years ago

    Hi, maybe I misunderstand you, please try this one

     

    complete_target =

      var target = 2

      return SUMX(SUMMARIZE(datatable,TM column),target)

     

PBI5851's avatar
PBI5851
Helper V
4 years ago

HoangHugo It is not working as it is summing up every single occurence. 

HoangHugo's avatar
HoangHugo
Solution Specialist
4 years ago

Hi, maybe I misunderstand you, please try this one

 

complete_target =

  var target = 2

  return SUMX(SUMMARIZE(datatable,TM column),target)