Measure with condition not showing Total

[crowntybass]

I need help with a measure 

if(SUM(SAP[Del depot Vol]) - SUM(SAP[del plant Vol]) < 0,0,SUM(SAP[Del depot Vol]) - SUM(SAP[del plant Vol]))

I want it to input zero if the cell is negative but I used the above dax and its not showing total

see image below

[tamerj1]

Hi @crowntybass 

you can follow this pattern 

Depot Actual Volume =
SUMX (
SUMMARIZE (
SAP,
SAP[Column1],
SAP[Column2],
SAP[Column3],
"@DepotVol", SUM ( SAP[Del depot Vol] ),
"@PlantVol", SUM ( SAP[del plant Vol] )
),
IF ( [@DepotVol] < [@PlantVol], 0, [@DepotVol] - [@PlantVol] )
)

where Column1, 2, 3 etc.. are the columns that compose the filter context of the visual. Could be one or more columns. 

[crowntybass]

Thank you for this

The subtraction didn't happen, and the condition also

Depot Actual Volume =

SUMX (

SUMMARIZE (

SAP,

SAP[Truck No New],

SAP[Del depot Vol],

SAP[del plant Vol],

"@DepotVol", SUM ( SAP[Del depot Vol] ),

"@PlantVol", SUM ( SAP[del plant Vol] )

),

IF([@DepotVol] < [@PlantVol], 0, [@DepotVol] - [@PlantVol] )

)

[tamerj1 · Accepted solution]

@crowntybass 

Only Truck No New is in the filter context of the visual. The other two columns are summarized by sum hence they are represented as implicit measures not as columns. Please try

Depot Actual Volume =

SUMX (

SUMMARIZE (

SAP,

SAP[Truck No New],

"@DepotVol", SUM ( SAP[Del depot Vol] ),

"@PlantVol", SUM ( SAP[del plant Vol] )

),

IF([@DepotVol] < [@PlantVol], 0, [@DepotVol] - [@PlantVol] )

)