Measure to identify sum = zero for a member not successful

[Anonymous]

Dear forum members,,

I have a rather easy appearing topic, but just can't get to the right DAX formula.

I'd like to show whether a part number (Sys_Plant_CAM) has a value equal zero in a certain column [lo_indreq] or not. The only obstacle is that the part number has various rows for single dates - some zero and some not zero.

I thought it would not be difficult using a Measure like the following to fill the total sum for all those part numbers:

CALCULATE(

    SUM('v_md04_latest'[lo_indreq]),

    ALLSELECTED('v_md04_latest'[Sys_Plant_CAM])

)

And then add a clolumn verifying whether the value in this measure is zero or not:

PIR_Y_N_2 = if(v_md04_latest[lo_indreq total for Sys_Plant_CAM]>0, "Y", "N")

But the measure does not show the total sum but always the distinct value, hence also the new column is not showing a unique value bot always depending on the date column:

Thanks for any help how to solve the issue.

[AlexisOlson · Accepted solution]

I think you want this instead:

CALCULATE (
    SUM ( 'v_md04_latest'[lo_indreq] ),
    ALLEXCEPT ( 'v_md04_latest', 'v_md04_latest'[Sys_Plant_CAM] )
)

You want to remove all filters except the Sys_Plant_CAM.

[Anonymous]

Thanks Alexis,

it worked perfectly as expected.

[Anonymous]

Try:

CALCULATE(

    SUM('v_md04_latest'[lo_indreq]),

    ALL('v_md04_latest'[calmonth]))

--Nate