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

Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi IamTDR 

The below should work for you.

 

Enrollment Measure = 
SUMX(
    GROUPBY( Enrollment_tbl, Enrollment_tbl[Territory], Enrollment_tbl[ProgCode] ),
    [Enrollment]
)

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski