Hi guys,

I created a calculated member using the following MDX query;

CALCULATE; 
CREATE MEMBER CURRENTCUBE.[Measures].[Dispute Accepted]
 AS 
        SUM(EXISTING([Measures].[Dispute Logged],([Dispute Status].[Status].&[Accepted]),([Date of Transaction].[Date].[All]))), 
FORMAT_STRING = "Standard", 
VISIBLE = 1 ,  DISPLAY_FOLDER = 'Dispute Management'  ;  

And this is the output i got when I tried to browse the cube. Please can someone help me and check what is wrong with the query. Thanks

Hi lilutchay,

According to your expression, I assume you want to get the number of accepted logged dispute for every date. Right?

In this scenario, you have fixed the scope and dimension, so it always return the same result when you call this measure in MDX. Since you are creating a measure to get number of "accepted" dispute, it's not related to the date and dispute logged. So in your expression, I think you just need to count the number of "Accept":

CREATE MEMBER CURRENTCUBE.[Measures].[Dispute Accepted]
 AS 
Count(Existing([Dispute Status].[Status].&[Accepted]))

If you have any question, please feel free to ask.

Regards,