Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
¡Hola!
Estoy creando un informe financiero sobre Power BI y estoy luchando para calcular los efectos de precio y consumo para diferentes productos.
El efecto del precio se calcula mediante: (ActualPrice - BudgetPrice) * ActualConsumption. Y se calcula el Efecto Consumo
por: (ActualCons. - BudgetCons.) * ActualPrice. Necesito dos medidas, una para el efecto precio y la otra para el efecto consumo.
@Jihwan_Kim @amitchandak @Fowmy @daxer
Solved! Go to Solution.
[Price Effect] =
SUMX(
DISTINCT( T[Product] ),
var PriceDelta =
CALCULATE(
sum( T[Actual] ) - sum( T[Budget] ),
// You should never slice by
// this column. It should
// be hidden.
T[Information] = "Price"
)
var ActualConsumption =
CALCULATE(
sum( T[Actual] ),
T[Information] = "Consump."
)
var Result = PriceDelta * ActualConsumption
return
Result
)
[Consumption Effect] =
SUMX(
DISTINCT( T[Product] ),
var ConsumptionDelta =
CALCULATE(
sum( T[Actual] ) - sum( T[Budget] ),
// You should never slice by
// this column. It should
// be hidden.
T[Information] = "Consump."
)
var ActualPrice =
CALCULATE(
sum( T[Actual] ),
T[Information] = "Price"
)
var Result = ConsumptionDelta * ActualPrice
return
Result
)
Por favor, vea la ADVERTENCIA sobre los modelos de una sola mesa:
[Price Effect] =
SUMX(
DISTINCT( T[Product] ),
var PriceDelta =
CALCULATE(
sum( T[Actual] ) - sum( T[Budget] ),
// You should never slice by
// this column. It should
// be hidden.
T[Information] = "Price"
)
var ActualConsumption =
CALCULATE(
sum( T[Actual] ),
T[Information] = "Consump."
)
var Result = PriceDelta * ActualConsumption
return
Result
)
[Consumption Effect] =
SUMX(
DISTINCT( T[Product] ),
var ConsumptionDelta =
CALCULATE(
sum( T[Actual] ) - sum( T[Budget] ),
// You should never slice by
// this column. It should
// be hidden.
T[Information] = "Consump."
)
var ActualPrice =
CALCULATE(
sum( T[Actual] ),
T[Information] = "Price"
)
var Result = ConsumptionDelta * ActualPrice
return
Result
)
Por favor, vea la ADVERTENCIA sobre los modelos de una sola mesa:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |