Forum Discussion

IamTDR's avatar
IamTDR
Responsive Resident
7 years ago
Solved

Help With a Sumx Measure

Morning I am working with a single table that has 'enrollment' numbers that I would like to sum up.  The trick is, each each territory/program has a distinct enrollment number.  I cannot simply sum ...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    7 years ago

    Hi IamTDR ,

     

    Take a try of this :

    Measure = SUMX(GROUPBY('BI BookInUse',[Program],[Territory],''BI BookInUse''[Enrollment]),[Enrollment])

    Best regards,

    Dina Ye

v-diye-msft's avatar
v-diye-msft
Community Support
7 years ago

Hi IamTDR ,

 

Take a try of this :

Measure = SUMX(GROUPBY('BI BookInUse',[Program],[Territory],''BI BookInUse''[Enrollment]),[Enrollment])

Best regards,

Dina Ye

IamTDR's avatar
IamTDR
Responsive Resident
7 years ago

Thanks!  Appreicate the aid

TDR