Forum Discussion

GG230011's avatar
GG230011
New Member
4 years ago

THE TOTAL OF A MEASURE

Hi everybody

I just wanna know the measure to calculate the sum of a measure 

I mean for example, I wanna sum "CXL ANT=measure"in order to have the total.

 

I hope you can understand me and help me

Thanks

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    This may surprise you but you cannot measure a measure. Instead you need to create a separate measure to compute the desired sum.  There's a phrase "Think like the Grand Total" which often helps you to create a measure that works both for the totals and for the individual cells.