What is the equivalent of PARTITION BY in SSAS (MDX)

Question

Hi All,

I can do

SELECT COUNT(ID) OVER(PARTITION BY CLAIMDESCR) AS CLAIMCNT

How can I achieve the same in SSAS on a single DIMENSION or multiple Dimensions?

Thanks

Answer 1

Hi @Lisa Kruger

You can refer to this link, it may be helpful for the problem you are experiencing.

https://stackoverflow.com/questions/54262256/ssas-mdx-calculated-measure-count-of-items-item-grouped-items-item-grou

Best regards,

Percy Tang

---

If the answer is the right solution, please click "Accept Answer". If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Lisa Kruger

How about this link case? The problem inside is very similar to yours.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b179a467-0e92-4d33-aee9-a85fe1e5e116/ssas-2008-mdx-how-to-count-members-in-dimension?forum=sqlanalysisservices

Best regards,

Percy Tang

---

If the answer is the right solution, please click "Accept Answer". If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.