question

Hi, I'm new to MDX and I'm want to convert t-sql query into mdx... SELECT count(distinct consumer) FROM table1 with (nolock) WHERE AMOUNT1+AMOUNT2!=0 and isnull(M_E,0) IN (0,1) and (SR_STATUS = 'D' and AMOUNT1+AMOUNT2!=0) AMOUNT1+AMOUNT2:- is a column in a fact table Table 1 :- is a fact table distinct consumer:- is a measure M_E is a dimension SR_STATUS is a dimension