Difference between two similar DAX measures

Hi all

Is there anyone that can tell me if there is a real difference between the following two DAX statements?

This one gives me duplicate values in the RITypeGroup Column. i.e. FAC and QS

This one does not give me duplicates (only FAC) which is what I want.

My Fact table looks like this: perfect it agrees to the visual output.

Here is the SQL for the table:

SELECT
RICLAIMSDEB.PolicyID, RICLAIMSDEB.ClaimID, RICLAIMSDEB.PeriodNo_SK, RICLAIMSDEB.CompanyID, RICLAIMSDEB.SystemID, RICLAIMSDEB.CurrencyID, RICLAIMSDEB.PolicyCurrencyID, RICLAIMSDEB.IndustryID,
RICLAIMSDEB.ProductTypeID, RICLAIMSDEB.FSBGroupingID, RICLAIMSDEB.PolicyClassID, RICLAIMSDEB.ProgramID, RICLAIMSDEB.InwardsRITypeID, RICLAIMSDEB.ClientPartyID, RICLAIMSDEB.BrokerPartyID, RICLAIMSDEB.MarketerID,
RICLAIMSDEB.BrokerMarketerID, RICLAIMSDEB.ParentPartyID, RICLAIMSDEB.DateOfLoss, RICLAIMSDEB.ClaimPaymentDate, RICLAIMSDEB.FinTimeID, RICLAIMSDEB.UWTimeID, RICLAIMSDEB.ClaimDateAdded, RICLAIMSDEB.ClaimLedgerDetails_Key,
RICLAIMSDEB.LedgerEntryTypeID, RICLAIMSDEB.LedgerEntrySubTypeID, RICLAIMSDEB.FinDocID, RICLAIMSDEB.DatePrinted, RICLAIMSDEB.ReportingClassID, RICLAIMSDEB.ReinsurerPartyID, RICLAIMSDEB.RIBrokerPartyID,
RICLAIMSDEB.RIArrangementID, RICLAIMSDEB.RITypeID, RICLAIMSDEB.ClaimEstTypeID, RICLAIMSDEB.RIGroupID, RICLAIMSDEB.TransactionType, RICLAIMSDEB.RITypeGroup,

sum([AmountInclVAT]) AS AmountInclVAT,
sum([AmountExclVAT]) AS AmountExclVAT,
sum([VAT]) AS VAT

FROM (

SELECT
FCRIP.PolicyID AS PolicyID,
FCRIP.ClaimID AS ClaimID,
FCRIP.PeriodNo_SK AS PeriodNo_SK,
FCRIP.CompanyID AS CompanyID,
FCRIP.SystemID AS SystemID,
FCRIP.CurrencyID AS CurrencyID,
0 AS PolicyCurrencyID,
FCRIP.IndustryID AS IndustryID,
FCRIP.ProductTypeID AS ProductTypeID,
FCRIP.FSBGroupingID AS FSBGroupingID,
FCRIP.PolicyClassID AS PolicyClassID,
FCRIP.ProgramID AS ProgramID,
FCRIP.InwardsRITypeID AS InwardsRITypeID,
FCRIP.ClientPartyID AS ClientPartyID,
FCRIP.BrokerPartyID AS BrokerPartyID,
FCRIP.MarketerID AS MarketerID,
FCRIP.BrokerMarketerID AS BrokerMarketerID,
FCRIP.ParentPartyID AS ParentPartyID,
FCRIP.DateOfLoss AS DateOfLoss,
FCRIP.ClaimPaymentDate AS ClaimPaymentDate,
0 AS RIClaimRecoveryDate, --CHECK--
FCRIP.FinTimeID AS FinTimeID,
FCRIP.UWTimeID AS UWTimeID,
FCRIP.ClaimDateAdded AS ClaimDateAdded,
--0 AS ClaimLedgerID,
FCRIP.ClaimLedgerDetails_Key AS ClaimLedgerDetails_Key,
FCRIP.LedgerEntryTypeID AS LedgerEntryTypeID,
FCRIP.LedgerEntrySubTypeID AS LedgerEntrySubTypeID,
--0 AS RIPaymentLedgerID,
FCRIP.FinDocID AS FinDocID,
0 AS DatePrinted, --CHECK--
FCRIP.ReportingClassID AS ReportingClassID,
FCRIP.ReinsurerPartyID AS ReinsurerPartyID,
FCRIP.RIBrokerPartyID AS RIBrokerPartyID,
FCRIP.RIArrangementID AS RIArrangementID,
FCRIP.RITypeID AS RITypeID,
CASE WHEN FCRIP.RITypeID IN (1, 11) THEN 'QS' WHEN FCRIP.RITypeID IN (3, 4) THEN 'FAC' WHEN FCRIP.RITypeID IN (2) THEN 'SP' WHEN FCRIP.RITypeID IN (7) THEN 'XOL' ELSE 'Unknown' END AS 'RITypeGroup',
FCRIP.ClaimEstTypeID AS ClaimEstTypeID,
--FCRIP.ClaimRILegID AS ClaimRILegID,
FCRIP.RIGroupID AS RIGroupID,
'Recoverable' AS TransactionType,
sum((FCRIP.AmountPaid)+(FCRIP.VATPaid)) AS AmountInclVAT,
sum(FCRIP.AmountPaid) AS AmountExclVAT,
sum(FCRIP.VATPaid) AS VAT

FROM FactClaimsRIPaid FCRIP

GROUP BY FCRIP.PolicyID, FCRIP.ClaimID, FCRIP.PeriodNo_SK, FCRIP.CompanyID, FCRIP.SystemID, FCRIP.CurrencyID, FCRIP.IndustryID, FCRIP.ProductTypeID, FCRIP.FSBGroupingID, FCRIP.PolicyClassID, FCRIP.ProgramID, FCRIP.InwardsRITypeID,
FCRIP.ClientPartyID, FCRIP.BrokerPartyID, FCRIP.MarketerID, FCRIP.BrokerMarketerID, FCRIP.ParentPartyID, FCRIP.DateOfLoss, FCRIP.ClaimPaymentDate, FCRIP.FinTimeID, FCRIP.UWTimeID, FCRIP.ClaimDateAdded, FCRIP.ClaimLedgerDetails_Key,
FCRIP.LedgerEntryTypeID, FCRIP.LedgerEntrySubTypeID, FCRIP.FinDocID, FCRIP.ReportingClassID, FCRIP.ReinsurerPartyID, FCRIP.RIBrokerPartyID, FCRIP.RIArrangementID, FCRIP.RITypeID, FCRIP.ClaimEstTypeID, FCRIP.RIGroupID

UNION ALL

SELECT
FRICR.PolicyID AS PolicyID,
FRICR.ClaimID AS ClaimID,
FRICR.PeriodNo_SK AS PeriodNo_SK,
FRICR.CompanyID AS CompanyID,
FRICR.SystemID AS SystemID,
0 AS CurrencyID,
FRICR.PolicyCurrencyID AS PolicyCurrencyID,
0 AS IndustryID,
FRICR.ProductTypeID AS ProductTypeID,
0 AS FSBGroupingID,
FRICR.PolicyClassID AS PolicyClassID,
0 AS ProgramID,
FRICR.InwardsRITypeID AS InwardsRITypeID,
FRICR.ClientPartyID AS ClientPartyID,
FRICR.BrokerPartyID AS BrokerPartyID,
FRICR.MarketerID AS MarketerID,
0 AS BrokerMarketerID,
0 AS ParentPartyID,
FRICR.DateOfLoss AS DateOfLoss,
0 AS ClaimPaymentDate,
FRICR.RIClaimRecoveryDate AS RIClaimRecoveryDate,--CHECK--
FRICR.FinTimeID AS FinTimeID,
FRICR.UWTimeID AS UWTimeID,
FRICR.ClaimDateAdded AS ClaimDateAdded,
--FRICR.ClaimLedgerID AS ClaimLedgerID,
0 AS ClaimLedgerDetails_Key, --CHECK--
FRICR.LedgerEntryTypeID AS LedgerEntryTypeID,
FRICR.LedgerEntrySubTypeID AS LedgerEntrySubTypeID,
--FRICR.RIPaymentLedgerID AS RIPaymentLedgerID,
0 AS FinDocID,
FRICR.DatePrinted AS DatePrinted,
0 as ReportingClassID,
FRICR.ReinsurerPartyID AS ReinsurerPartyID,
FRICR.RIBrokerPartyID AS RIBrokerPartyID,
FRICR.RIArrangementID AS RIArrangementID,
FRICR.RITypeID AS RITypeID,
CASE WHEN FRICR.RITypeID IN (1, 11) THEN 'QS' WHEN FRICR.RITypeID IN (3, 4) THEN 'FAC' WHEN FRICR.RITypeID IN (2) THEN 'SP' WHEN FRICR.RITypeID IN (7) THEN 'XOL' ELSE 'Unknown' END AS 'RITypeGroup',
0 AS ClaimEstTypeID,
--0 AS ClaimRILegID,
0 AS RIGroupID,
'Recovered' AS TransactionType,
sum((FRICR.RIClaimRecoveryAmount)+(FRICR.RIClaimRecoveryVATAmount)) AS AmountInclVAT,
sum(FRICR.RIClaimRecoveryAmount) AS AmountExclVAT,
sum(FRICR.RIClaimRecoveryVATAmount) AS VAT

FROM FactRIClaimsRecovered FRICR

GROUP BY FRICR.PolicyID, FRICR.ClaimID, FRICR.PeriodNo_SK, FRICR.CompanyID, FRICR.SystemID, FRICR.PolicyCurrencyID, FRICR.ProductTypeID, FRICR.PolicyClassID, FRICR.InwardsRITypeID,
FRICR.ClientPartyID, FRICR.BrokerPartyID, FRICR.MarketerID, FRICR.DateOfLoss, FRICR.RIClaimRecoveryDate, FRICR.FinTimeID, FRICR.UWTimeID, FRICR.ClaimDateAdded,
FRICR.LedgerEntryTypeID, FRICR.LedgerEntrySubTypeID, FRICR.DatePrinted, FRICR.ReinsurerPartyID, FRICR.RIBrokerPartyID, FRICR.RIArrangementID, FRICR.RITypeID

) RICLAIMSDEB

GROUP BY RICLAIMSDEB.PolicyID, RICLAIMSDEB.ClaimID, RICLAIMSDEB.PeriodNo_SK, RICLAIMSDEB.CompanyID, RICLAIMSDEB.SystemID, RICLAIMSDEB.CurrencyID, RICLAIMSDEB.PolicyCurrencyID, RICLAIMSDEB.IndustryID,
RICLAIMSDEB.ProductTypeID, RICLAIMSDEB.FSBGroupingID, RICLAIMSDEB.PolicyClassID, RICLAIMSDEB.ProgramID, RICLAIMSDEB.InwardsRITypeID, RICLAIMSDEB.ClientPartyID, RICLAIMSDEB.BrokerPartyID, RICLAIMSDEB.MarketerID,
RICLAIMSDEB.BrokerMarketerID, RICLAIMSDEB.ParentPartyID, RICLAIMSDEB.DateOfLoss, RICLAIMSDEB.ClaimPaymentDate, RICLAIMSDEB.FinTimeID, RICLAIMSDEB.UWTimeID, RICLAIMSDEB.ClaimDateAdded, RICLAIMSDEB.ClaimLedgerDetails_Key,
RICLAIMSDEB.LedgerEntryTypeID, RICLAIMSDEB.LedgerEntrySubTypeID, RICLAIMSDEB.FinDocID, RICLAIMSDEB.DatePrinted, RICLAIMSDEB.ReportingClassID, RICLAIMSDEB.ReinsurerPartyID, RICLAIMSDEB.RIBrokerPartyID,
RICLAIMSDEB.RIArrangementID, RICLAIMSDEB.RITypeID, RICLAIMSDEB.ClaimEstTypeID, RICLAIMSDEB.RIGroupID, RICLAIMSDEB.TransactionType, RICLAIMSDEB.RITypeGroup