question

Rahul_Sharma avatar image
Rahul_Sharma asked

filter measure based on different dimension

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
ssasmdx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.