Challenge Multiple Dax variables and return

[rsanyoto]

Hi guys,

my requirement as following:

if productionorder status has value released then calculate the measure called  [VPO2]

if productionorder status has value finished then calculate the measure called [VPO]

I tried to create a new VPO MeasureVariabel but its gave an error because a function calcualte has been used in a true/false expression that is used as a table filter expression. this is not allowed

VPO MeasureVariabel =

VAR VPOFinished = FILTER(Fact_ProductionOrderLine, Fact_ProductionOrderLine[ProductieStatus] = "released")

VAR VPOReleased = FILTER(Fact_ProductionOrderLine, Fact_ProductionOrderLine[ProductieStatus] = "finished")

RETURN

CALCULATE([VPO 2],VPOReleased,[VPO],VPOFinished )

Any suggestions to fix/change my VPO MeasureVariabel?

Many thanks!

[amitchandak · Accepted solution]

@rsanyoto , Try like

new measure = calculate([VPO2],FILTER(Fact_ProductionOrderLine, Fact_ProductionOrderLine[ProductieStatus] = "released")) +
calculate([VPO],FILTER(Fact_ProductionOrderLine, Fact_ProductionOrderLine[ProductieStatus] = "finished"))

[rsanyoto]

@amitchandak  thanks for your help. Your solution works!

[vanessafvg]

you look like you missing an if statment, if your variable is true then then else 0

ie.

VPO MeasureVariabel =
VAR VPOFinished =
FILTER (
Fact_ProductionOrderLine,
Fact_ProductionOrderLine[ProductieStatus] = "released"
)
VAR VPOReleased =
FILTER (
Fact_ProductionOrderLine,
Fact_ProductionOrderLine[ProductieStatus] = "finished"
)
RETURN
IF ( VPOReleased = 1, [VPO 2], [VPO] )