Not sure this makes sense. What I have is an average payment amount which will be sliced by payer. I want to see what is payer1's percent average of the overall average from all payers.
I have a calculated member for average payment amount already:
CREATE MEMBER CURRENTCUBE.[Measures].[Average Payment Amount]
AS
CASE
WHEN IsEmpty([Measures].[Count]) OR [Measures].[Count] = 0
THEN NULL
ELSE ([Measures].[Payment Amount] / [Measures].[Count])
END,
FORMAT_STRING = "currency",
NON_EMPTY_BEHAVIOR = {[Payment Amount]},
ASSOCIATED_MEASURE_GROUP = 'Payment',
VISIBLE = 1
Any help is appreciated. I was thinking I need to do something with currentmember, but then I couldn't think of how I would have the denominator be all payers. I dunno, hopefully it's easier than I'm making it.

**View Complete Post**

## For loop to find sum and average