Dax Calculation in Column to Measure

[Fsciencetech]

Hi Folks,

Need you help, I am stuck in one dax, I was tried below calculation on column, the result is fine but I need this calculation on measure.

could you please help me on this.

MissPart =

VAR Part = IF(OSMSData[OSLastReplanDate] = MAX(OSMSData[OSLastReplanDate])

&& NOT(ISBLANK(OSMSData[OSMaterialRecoveryDate])) && NOT(ISBLANK(OSMSData[SapSoli]))

&& FORMAT(OSMSData[OSMaterialRecoveryDate],"Text") <> "TBC" && FORMAT(OSMSData[OSMaterialRecoveryDate],"Text") <>" ",

OSMSData[ComponentPartNumber])

RETURN

CALCULATE(

Part,

FILTER(OSMSData,

NOT(ISBLANK(Part))

),

SUMMARIZE(OSMSData,OSMSData[ComponentPartNumber],OSMSData[Order_CustomerDG],OSMSData[SapSoli],OSMSData[MaxOsLastreplandate1],OSMSData[OSLocation])

)

[v-henryk-mstf]

Hi @Fsciencetech ,

Can you provide test data link from OneDrive, because if I don’t know the relationship between the specific data model and the table, I can’t do further testing.

Let me know immediately, looking forward to your reply.

Best Regards,
Henry