with
member distinctuserid as distinctcount([Measures].[User ID])
select
{ distinctuserid } on columns,
[Dim Date].[Hierarchy].[Day] on rows
from [Usage]
我照着葫芦画瓢,结果得出的结果全是1
...全文
1431打赏收藏
事实表里有一个UserID字段,我如何distinctcount(userid)
我的事实表(用户操作记录Usage)里有各种维度字段,但我没有把UserID作为一个维度表,我如何DistinctCount(UserID)呢? 需要把UserID也做成一个维度表吗? with member distinctuserid as distinctcount([Measures].[User ID]) select { distinctuserid } on columns, [Dim Date].[Hierarchy].[Day] on rows from [Usage] 我照着