• Martin,

    Thanks for the response.

    I do not think there is much performance difference between count() and sum() either.

    I do need an additional measure - Distinct Count of Member ID. If I understand correctly, with either a Sum() measure or a Count() measure in the cube, this measure can be created. Some people suggest putting Distinct Count in its own measure group for performance reason.