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

parry2k's avatar
parry2k
Super User
7 years ago

IamTDR try following 

 

Sum Enrollment = 
SUMX(
SUMMARIZECOLUMNS( Table[Territory], Table[ProgCode]),
CALCULATE( SUM( Table[Enrollment] ) )
)
IamTDR's avatar
IamTDR
Responsive Resident
7 years ago

Thanks for the suggestions but so far I am not receiving the desired results.  I inserted an image of what my visual currently looks like.  The Total Enrollment number should total to 12,144 and not 60,720.  My Total Enrollment number is based on Territory and Program.

 

 

 

Measure currently being used.

  • 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