blocks|key|672019|text|WITH+
++++MEMBER+[Measures].[amount]+as+
++++++++COUNT(
++++++++++++[your_dimension].[your_dimension_property].Members
++++++++)+
SELECT+{[Measures].[amount]}+ON+COLUMNS+
FROM+[your_awesome_cube]+|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|672020|这样的代码将向您返回维度中的成员数量，COUNT方法具有以下语法Count(Set_Expression+[+,+(+EXCLUDEEMPTY+%7C+INCLUDEEMPTY+)+]+)，因此您可以执行许多操作，如过滤搜索|unstyled|offset|length|style|CODE|672021|entityMap^0|0|J|5|W|1O|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|N|8|@$G|O|H|P|I|J]|$G|Q|H|R|I|J]]|9|@]|A|$]]|$1|K|3|-4|5|F|7|S|8|@]|9|@]|A|$]]]|L|$]]

<pre><code>WITH 
 MEMBER [Measures].[amount] as 
 COUNT(
 [your_dimension].[your_dimension_property].Members
 ) 
SELECT {[Measures].[amount]} ON COLUMNS 
FROM [your_awesome_cube] 
</code></pre>

A code like this will return to you the amount of members in your dimension, the <code>COUNT</code> method have this syntax 
<code>Count(Set_Expression [ , ( EXCLUDEEMPTY | INCLUDEEMPTY ) ] )</code>
so you can do a lot of things, like filter your search

blocks|key|937074|text|在多维数据集中创建计数或非重复计数的度量值。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|937075|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Create a measure in the cube that is a count or distinct count.

blocks|key|2987106|text|1)打开立方体|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2987107|2)右键单击该度量所在的事实表|2987108|3)选择New+Measure...|offset|length|style|CODE|2987109|4)下拉列表，选择聚合|2987110|5)在源列部分，选择要聚合的列(如果找不到，请单击底部的show+all+columns+-这取决于您要聚合的内容)|2987111|entityMap^0|0|0|4|E|0|0|S|G|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@$F|S|G|T|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|V|8|@$F|W|G|X|H|I]]|9|@]|A|$]]|$1|N|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|O|$]]

1) open the cube

2) Right click on the fact table on which that measure sits

3) Select <code>New Measure...</code>

4) Dropdown the list and select the aggregation

5) In the source column section, select the column you want the aggregation on (if u cant find it, click on <code>show all columns</code> on the bottom- this depends on what you are aggregating)

blocks|key|2987154|text|成员Measures.Counts为your_dimension.your_dimension_property.Children.COUNT|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2987155|从your_awesome_cube中选择0上的Measures.Counts|2987156|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

with member 
Measures.Counts as
[your_dimension].[your_dimension_property].Children.COUNT

select Measures.Counts on 0
FROM [your_awesome_cube]

blocks|key|2987241|text|当你说记录计数时，你基本上是在说你的行轴的有效组合。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2987242|让我们举一个基本的例子，查询返回3637行，其中1行是列名称行。|2987243|select+[Measures].[Sales+Amount]+on+columns,+
(
[Customer].[Country].[Country],
[Product].[Product].[Product]
)+on+rows
from+[Adventure+Works]|code-block|syntax|javascript|2987244|现在，为了在不运行查询的情况下获得行数，让我们将组合放入count函数中，并将count函数放入运行时度量中|2987245|这将返回3636行。在计数为member+Measures.rowCount+((Customer.Country.Country，Product.Product.Product))的情况下，从Adventure中选择列上的Measures.rowCount|2987246|请注意，我还没有删除行上的null组合。接下来让我们这样做|2987247|该查询返回2101行，同样是列标题中的一行。在Adventure中的列上选择Measures.Sales+Amount，在行上选择非空(+Customer.Country.Country，Product.Product.Product|2987248|现在让我们计算一下行数|2987249|这将返回2100行。使用member+Measures.rowCount作为count(非空((+Customer.Country.Country，Product.Product.Product)，{Measures.Sales+Measures.rowCount+}+))从Adventure中选择列上的数量|2987250|到目前为止，我们只有一个度量值组的度量，现在让我们尝试多个度量值组。|2987251|select+{[Measures].[Sales+Amount],[Measures].[Internet+Sales+Amount]}+on+columns,+
non+empty+
(
[Customer].[Country].[Country],
[Product].[Product].[Product]
)+on+rows
from+[Adventure+Works]
//Cell+set+consists+of+2101+rows+and+3+columns.

//Wrong+way
with+member+[Measures].[rowCount]
as+
count(nonempty((+[Customer].[Country].[Country],[Product].[Product].[Product])
,{[Measures].[Internet+Sales+Amount]}
))
select+[Measures].[rowCount]+on+columns+from+[Adventure+Works]
//935

//Right+way
with+member+[Measures].[rowCount]
as+
count(nonempty((+[Customer].[Country].[Country],[Product].[Product].[Product])
,{[Measures].[Sales+Amount],[Measures].[Internet+Sales+Amount]}
))
select+[Measures].[rowCount]+
on+columns+from+[Adventure+Works]
///2100|2987252|请注意，当我们仅使用单个度量时，结果可能不正确。如果我们使用的度量值为空值，则组合将被删除。在我们的行中，另一个度量将确保组合出现。|2987253|现在让我们在图片中添加一个滤镜。|2987254|select+{[Measures].[Sales+Amount],[Measures].[Internet+Sales+Amount]}+on+columns,+
non+empty
filter(+
(
[Customer].[Country].[Country],
[Product].[Product].[Product]
)
,[Measures].[Internet+Sales+Amount]>5000)+on+rows
from+[Adventure+Works]
//Cell+set+consists+of+586+rows+and+3+columns.

//Wrong+way
with+member+[Measures].[rowCount]
as+
count(nonempty((+[Customer].[Country].[Country],[Product].[Product].[Product])
,{[Measures].[Sales+Amount],[Measures].[Internet+Sales+Amount]}
))
select+[Measures].[rowCount]+
on+columns+from+[Adventure+Works]
//2100

//Right+way
with+member+[Measures].[rowCount]
as+
count(nonempty(
filter(([Customer].[Country].[Country],[Product].[Product].[Product]),[Measures].[Internet+Sales+Amount]>5000)+
,{[Measures].[Sales+Amount],[Measures].[Internet+Sales+Amount]}
))
select+[Measures].[rowCount]+
on+columns+from+[Adventure+Works]
///585|2987255|同样，直到我给了RowCount度量我在行轴上的确切位置，它才会失败。|2987256|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|19|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1A|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|1B|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|1C|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|1D|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1E|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1F|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1G|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1H|8|@]|9|@]|A|$]]|$1|W|3|X|5|F|7|1I|8|@]|9|@]|A|$G|H]]|$1|Y|3|Z|5|6|7|1J|8|@]|9|@]|A|$]]|$1|10|3|11|5|6|7|1K|8|@]|9|@]|A|$]]|$1|12|3|13|5|F|7|1L|8|@]|9|@]|A|$G|H]]|$1|14|3|15|5|6|7|1M|8|@]|9|@]|A|$]]|$1|16|3|-4|5|6|7|1N|8|@]|9|@]|A|$]]]|17|$]]

When you say record count, you basicly are saying the valid combinations of your row axis. 

Lets take a basic example, the query returns 3637 rows, of which 1 row is parctically the column name row. 

<pre><code>select [Measures].[Sales Amount] on columns, 
(
[Customer].[Country].[Country],
[Product].[Product].[Product]
) on rows
from [Adventure Works]
</code></pre>

Now to get the row count without running the query, lets put the combinations in count function and put the count function in a runtime measure

This Returns 3636 row.
 with member [Measures].[rowCount]
 as 
 count(([Customer].[Country].[Country],[Product].[Product].[Product]))
 select [Measures].[rowCount] on columns from [Adventure Works]

Notice I have not eleminated the null combinations on rows. Lets do that next

The query returns 2101 rows , again one row from column headers.
 select [Measures].[Sales Amount] on columns, 
 non empty 
 (
 [Customer].[Country].[Country],
 [Product].[Product].[Product]
 ) on rows
 from [Adventure Works]

Now lets count the rows 

This returns 2100 rows.
 with member [Measures].[rowCount]
 as 
 count(nonempty(( [Customer].[Country].[Country],[Product].[Product].[Product])
 ,{[Measures].[Sales Amount]}
 ))
 select [Measures].[rowCount] 
 on columns from [Adventure Works]

Till now we had measure from just one measure group, now lets try with multiple measure groups. 

<pre><code>select {[Measures].[Sales Amount],[Measures].[Internet Sales Amount]} on columns, 
non empty 
(
[Customer].[Country].[Country],
[Product].[Product].[Product]
) on rows
from [Adventure Works]
//Cell set consists of 2101 rows and 3 columns.

//Wrong way
with member [Measures].[rowCount]
as 
count(nonempty(( [Customer].[Country].[Country],[Product].[Product].[Product])
,{[Measures].[Internet Sales Amount]}
))
select [Measures].[rowCount] on columns from [Adventure Works]
//935

//Right way
with member [Measures].[rowCount]
as 
count(nonempty(( [Customer].[Country].[Country],[Product].[Product].[Product])
,{[Measures].[Sales Amount],[Measures].[Internet Sales Amount]}
))
select [Measures].[rowCount] 
on columns from [Adventure Works]
///2100
</code></pre>

Notice when we use just a single measure the result may not be correct . If the measure we use has a null value then the combination would be removed. Where as in our rows the other measure will ensure that the combination appears.

Now Lets add a filter to the picture. 

<pre><code>select {[Measures].[Sales Amount],[Measures].[Internet Sales Amount]} on columns, 
non empty
filter( 
(
[Customer].[Country].[Country],
[Product].[Product].[Product]
)
,[Measures].[Internet Sales Amount]&gt;5000) on rows
from [Adventure Works]
//Cell set consists of 586 rows and 3 columns.

//Wrong way
with member [Measures].[rowCount]
as 
count(nonempty(( [Customer].[Country].[Country],[Product].[Product].[Product])
,{[Measures].[Sales Amount],[Measures].[Internet Sales Amount]}
))
select [Measures].[rowCount] 
on columns from [Adventure Works]
//2100

//Right way
with member [Measures].[rowCount]
as 
count(nonempty(
filter(([Customer].[Country].[Country],[Product].[Product].[Product]),[Measures].[Internet Sales Amount]&gt;5000) 
,{[Measures].[Sales Amount],[Measures].[Internet Sales Amount]}
))
select [Measures].[rowCount] 
on columns from [Adventure Works]
///585
</code></pre>

Again till i gave the RowCount measure the exact senario that I have on my row axis it fails.

Can any one tell me how to get the record count that is a result of a MDX query?I have tried various methods and I haven't really got a solution for that.I am a beginner in MDX queries.

MDX Record Count

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

有人能告诉我如何获得MDX查询的结果的记录数吗?我已经尝试了各种方法，但我还没有真正得到解决方案。我是MDX查询的初学者。

问MDX记录计数
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MDX记录计数EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MDX记录计数
EN