how to count in ssas?

Question

Hi.
I have such a TSQL query.
select count(*)over(partition by clrgroup) as clrcounts from dbo.DimAdress
Now the question is how do I achieve the same in SSAS.
Thanks.

Answer 1

Hi @vava

In TSQL, the role of this query is to count the number of group members by grouping.

In SSAS, there is also MDX with a similar effect.

This thread may be able to help you.

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.