Forum Discussion

Fsciencetech's avatar
Fsciencetech
Icon for Helper III rankHelper III
5 years ago

Dax Calculation in Column to Measure

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])
)
Need Help

1 Reply

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    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