如何在DAX中复制MDX Sum函数的行为

本文介绍了如何在DAX中复制MDX Sum函数的行为的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在尝试为MDX查询编写等效的DAX表达式，如下所述- MDX查询就像- 我已经有一个名称为Measure1的计算量度，并且我正在尝试使用Measure1计算另一个量度(假设Measure2) 创建成员CurrentCube.[Measures].[Measure2]为 Sum([DimensionX].[X1].[X1]，iif([Measures].[Measure1]> 100,1，null)) 如何在DAX中复制相同内容? 我尝试过使用COUNTROWS函数之类的多种方法来至少获取行数，但是即使是基本结果也无法按预期生成. 在这方面的任何帮助将不胜感激. 提前谢谢， Abhi8

Hi, I am trying to write an equivalent DAX expression for a MDX query as mentioned below- The MDX query goes like - I already have a calculated measure with name Measure1 and I am trying to calculate another measure(suppose Measure2) using Measure1 Create Member CurrentCube.[Measures].[Measure2] as Sum([DimensionX].[X1].[X1],iif([Measures].[Measure1] > 100,1,null)) How to replicate the same in DAX? I have tried multiple methods like COUNTROWS function to get the no of rows at least, but even the basic result is not generating as expected. Any help in this regard will be greatly appreciated. Thanks in advance, Abhi8

推荐答案

Measure2:= SUMX( VALUES('Dimension'[X1]), IIF( [Measure1] > 100, 1, BLANK() ) )

在大多数情况下，性能应该不错.

Performance should be fine in most cases.