DAX syntax error for ...

Hi ARWCL 

Based on your data and the final goal, i create the following measures.

Note:there are no relationships among tables.

MEASURE =
VAR filterdate =
    IF (
        ISFILTERED ( DateTable[Date] ),
        MAX ( DateTable[Date] ),
        MAXX ( ALLSELECTED ( 'Value'[Date] ), [Date] )
    )
VAR filterassetid =
    CALCULATETABLE (
        VALUES ( 'FamilyMembers'[AssetID] ),
        FamilyMembers[OwnershipStartDate] <= filterdate,
        OR (
            FamilyMembers[OwnerShipEndDate] >= filterdate,
            ISBLANK ( FamilyMembers[OwnerShipEndDate] )
        )
    )
VAR maxdate =
    MAXX (
        FILTER (
            ALLSELECTED ( 'Value' ),
            [AssetID]
                IN filterassetid
                    && [AssetID]
                        IN VALUES ( 'Value'[AssetID] )
                            && [Date] <= filterdate
        ),
        [Date]
    )
VAR maxvalue =
    MAXX (
        FILTER (
            ALLSELECTED ( 'Value' ),
            [Date] = maxdate
                && [AssetID]
                    IN VALUES ( 'Value'[AssetID] )
                        && [AssetID] IN filterassetid
        ),
        [Value]
    )
VAR subvalue =
    SUMX (
        FILTER (
            ALLSELECTED ( 'Value' ),
            [ParentAssetID]
                IN VALUES ( 'Value'[AssetID] )
                    && [ParentAssetID]
                    IN filterassetid
                        && [Date] <= filterdate
        ),
        [Value]
    )
VAR ownerper =
    MAXX (
        FILTER (
            ALLSELECTED ( FamilyMembers ),
            [AssetID]
                IN VALUES ( FamilyMembers[AssetID] )
                    && [AssetID]
                        IN VALUES ( 'Value'[AssetID] )
                            && [AssetID] IN filterassetid
        ),
        [OwnershipPercentage]
    )
RETURN
    ( maxvalue + subvalue * ownerper ) * ownerper

Measure2 =
VAR a =
    ADDCOLUMNS (
        SUMMARIZE ( ALLSELECTED ( 'Value' ), [AssetID] ),
        "Measure", [Measure]
    )
RETURN
    SUMX ( FILTER ( a, [AssetID] IN VALUES ( 'Value'[AssetID] ) ), [Measure] )

Then put the measure2 to the card.

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.