https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/OR-function/m-p/2029924#M45496 <P>Anonymous</LI-USER>&nbsp;Well, here is the code cleaned up:</P> <LI-CODE lang="markup">Yield %_latest_total = IF ( ( Fact_Yield_Detail_Latest[Item_Group_deduce] = "AP3" ) || ( Fact_Yield_Detail_Latest[Item_Group_deduce] = "AF1" ), CALCULATE ( SUM ( Fact_Yield_Detail_Latest[Good_Qty] ), Fact_Yield_Detail_Latest[Process_Description] = "Double Check" ) / CALCULATE ( SUM ( Fact_Yield_Detail_Latest[Start_Qty] ), Fact_Yield_Detail_Latest[Process_Description] = "Lathe Cutting" ), IF ( Fact_Yield_Detail_Latest[Item_Group_deduce] = "SP2 (toric)" || ( Fact_Yield_Detail_Latest[Item_Group_deduce] = "SP2 (non-toric)" ), CALCULATE ( SUM ( Fact_Yield_Detail_Latest[Good_Qty] ), Fact_Yield_Detail_Latest[Process_Description] = "Double Check" ) / CALCULATE ( SUM ( Fact_Yield_Detail_Latest[Start_Qty] ), Fact_Yield_Detail_Latest[Process_Description] = "UV mould prep" ), 0 ) )</LI-CODE> <P>What I would suggest is to return hard coded values for each possible condition. Then you can check your logic.</P> Sat, 21 Aug 2021 18:37:06 GMT Greg_Deckler 2021-08-21T18:37:06Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/OR-function/m-p/2029915#M45493 <P>This post has closed.</P> Thu, 26 Aug 2021 16:47:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/OR-function/m-p/2029915#M45493 Anonymous 2021-08-26T16:47:54Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/OR-function/m-p/2029924#M45496 <P>Anonymous</LI-USER>&nbsp;Well, here is the code cleaned up:</P> <LI-CODE lang="markup">Yield %_latest_total = IF ( ( Fact_Yield_Detail_Latest[Item_Group_deduce] = "AP3" ) || ( Fact_Yield_Detail_Latest[Item_Group_deduce] = "AF1" ), CALCULATE ( SUM ( Fact_Yield_Detail_Latest[Good_Qty] ), Fact_Yield_Detail_Latest[Process_Description] = "Double Check" ) / CALCULATE ( SUM ( Fact_Yield_Detail_Latest[Start_Qty] ), Fact_Yield_Detail_Latest[Process_Description] = "Lathe Cutting" ), IF ( Fact_Yield_Detail_Latest[Item_Group_deduce] = "SP2 (toric)" || ( Fact_Yield_Detail_Latest[Item_Group_deduce] = "SP2 (non-toric)" ), CALCULATE ( SUM ( Fact_Yield_Detail_Latest[Good_Qty] ), Fact_Yield_Detail_Latest[Process_Description] = "Double Check" ) / CALCULATE ( SUM ( Fact_Yield_Detail_Latest[Start_Qty] ), Fact_Yield_Detail_Latest[Process_Description] = "UV mould prep" ), 0 ) )</LI-CODE> <P>What I would suggest is to return hard coded values for each possible condition. Then you can check your logic.</P> Sat, 21 Aug 2021 18:37:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/OR-function/m-p/2029924#M45496 Greg_Deckler 2021-08-21T18:37:06Z