计算一些创建总度量值的某些成员的度量值 [英] calculate measure for some members that create some percent of total measure

问题描述

我们有一个多维数据集，它具有一个度量(佣金金额)和两个维度的客户和日期. 我要计算(创建佣金金额的80％的客户数)与(总客户数)的比率 重要的是要说客户是根据他们的佣金金额排序的 如何解决这个问题?而必须使用什么来解决该查询?

We have a cube that it has one measure (Commission Amount) and two dimensions customer and Date. I want calculate ratio of (count of customers who create 80 percent of Commission Amount) to (count of total customer) It is important to say that customers are sorted base on their Commission Amount How can solve this problem? And what must use to solve this query?

推荐答案

与Danylo基本相同的方法-我只是添加了一个额外的COUNT，并删除了一些可能多余的EXISTING关键字:

Basically the same approach as Danylo - I just added an extra COUNT and deleted some, possibly redundant, EXISTING keywords:

DIVIDE(
  COUNT(
    TOPPERCENT(
      {[Customer].[Customer].[Customer].MEMBERS}, 
      80,  
      [Measures].[Commission Amount]  
    )
  )
  ,[Customer].[Customer].[Customer].MEMBERS.COUNT
)

这篇关于计算一些创建总度量值的某些成员的度量值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！