DAX过滤器 [英] DAX Filter
问题描述
有一些商业案例,我们需要计算产品的实际商店数量。
业务定义: - 商店数量的计数 <货物单位> 0
Good Unit的数量在Cube的Fact Table中。事实表中的记录计数接近约6000万。
实际没有商店=计算(DISTINCTCOUNT('Aas vwLocation'[StoreName]),FILTER('Aas vwLocation ',[LocationType] =" STORE"),FILTER('FCT_Goods',SUM(FCT_Goods [商品单位])> 0)))
最后一个过滤器(FACT表上的FILTER('FCT_Goods',SUM(FCT_Goods [Goods Unit])> 0))导致DAX超时。我们如何优化DAX。
虽然 FILTER主要适用于DIM表。请建议
There is some business case where we need to calculate Actual Number of Store for which the Product.
Business Definition:- Count of No. of stores where Goods Unit> 0
No. Of Good Unit is in Fact Table in Cube . The Count of Records in Fact Table is near about 60Million.
Actual No Store = CALCULATE(DISTINCTCOUNT('Aas vwLocation'[StoreName]),FILTER('Aas vwLocation',[LocationType]="STORE"),FILTER('FCT_Goods',SUM(FCT_Goods[Goods Unit])> 0))
The Last Filter (FILTER('FCT_Goods',SUM(FCT_Goods[Goods Unit])> 0)) on FACT table is causing the DAX to get timeout . How can we optimize the DAX.
Although FILTER apply mostly on DIM table . Please suggest
推荐答案
您能否建议
这篇关于DAX过滤器的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!