Tengo DAX aquí, que necesita cierta optimización. En el sentido de que en este momento, cuando estoy usando este DAX en la visualización, está tardando mucho tiempo / memoria en cargarse. ¿Alguna sugerencia sobre cómo puedo optimizar?
Cambio de precio % Mes-Año Pasado Cliente =
Tabla VAR1 =
CALCULABLE (
ADDCOLUMNS (
RESUMIR ( fact_CustInvoice, fact_CustInvoice[id_dim_Customer], fact_CustInvoice[id_dim_Item],fact_CustInvoice[UniqueKey]),
"SalesQty", [Cantidad de ventas],
"SalesQtyLY", [Cantidad de ventas LY],
"Sales_", [Ventas],
"SalesLY", [Ventas LY]
)
)
Tabla VAR2 =
ADDCOLUMNS (
tabla1,
"Incluir",
SI (
ISBLANK ( [SalesQty] ) || ISBLANK ( [SalesQtyLY] )
|| ISBLANK ( [Ventas] )
|| ISBLANK ( [Sales_] )
|| [SalesQty] <= 0
|| [SalesQtyLY] <= 0
|| [SalesLy] <= 0
|| [Sales_] < = 0,
FALSO
VERDADERO
)
)
Tabla VAR3 =
ADDCOLUMNS (
tabla2,
"AvgPrice", IF ( [Include] = TRUE, DIVIDE ( [Sales_], [SalesQty] ), 0 ),
"AvgPriceLY", IF ( [Include] = TRUE, DIVIDE ( [SalesLY], [SalesQtyLy] ), 0 ),
"Resultado",
IF ( [Incluir] = VERDADERO, [Sales_],0)
)
Tabla VAR4 =
SUMMARIZE(table3,[Include],fact_CustInvoice[UniqueKey],"distinctcount",IF([Include]=TRUE(),DISTINCTCOUNTNOBLANK(fact_CustInvoice[UniqueKey]),BLANK()))
VAR AveragePriceCurrentYear = SUMX ( FILTER ( tabla3, [Include] = TRUE ), [AvgPrice] )
VAR AveragePriceLastYear = SUMX ( FILTER ( tabla3, [Include] = TRUE ), [AvgPriceLY] )
VAR SalesForItemCustomerBothPeriods= SUMX ( FILTER ( tabla3, [Include] = TRUE ), [Resultado] )
Condiciones VAR=SUMX(table4,[distinctcount])
VAR PriceDev = IF(ISBLANK(DIVIDE(AveragePriceCurrentYear,AveragePriceLastYear)),BLANK(),DIVIDE(AveragePriceCurrentYear,AveragePriceLastYear)-1)
DEVOLUCIÓN
SI (
conditions=1,IF(ISBLANK(DIVIDE(AveragePriceCurrentYear,AveragePriceLastYear)),BLANK(),DIVIDE(AveragePriceCurrentYear, AveragePriceLastYear)-1),
[Impacto del cambio de precio mes-año pasado cliente]/ SalesForItemCustomerBodos
)
KR
Sandeep
