Total using SUMX() and calculated table is not correct

[Serdia]

I have a measure that used SUMX and calculated table. 
How can I get a total of column "Open" that is created within calculated table. 
On a picture you see 12, which is incorrect. The correct number is 335.

TestMeasure =
SUMX (
    ADDCOLUMNS (
        SUMMARIZE (
            FILTER (
                SumByClaim,
                SumByClaim[TransactionDate] >= FIRSTDATE ( SumByClaim[TransactionDate] )
                    && SumByClaim[TransactionDate] <= LASTDATE ( SumByClaim[TransactionDate] )
            ),
            SumByClaim[ClaimNumber],
            SumByClaim[ClaimantID],
            SumByClaim[ClaimStatus],
            "MaxTransDate", MAX ( SumByClaim[TransactionDate] )
        ),
        "Open", IF (
            SumByClaim[ClaimStatus] = "Open"
                && [MaxTransDate] = MAX ( SumByClaim[TransactionDate] ),
            1,
            0
        )
    ),
    [Open]
)

[v-yuta-msft]

@Serdia ,

There should be some wrong with logic of the "IF" in your measure. Could you please share some sample data and clarify more details about the expected result?

Regards,

Jimmy Tao

[Serdia]

The sample .pbix file could be found here:

https://www.dropbox.com/s/9dsnylng70t5a8i/Count%20Open%20and%20Closed%20at%20Point%20of%20time.pbix?...

Thank you 

[amitchandak]

In the filter these is no join with

SumByClaim[ClaimNumber],
            SumByClaim[ClaimantID]

Is it by design. You should take them in group by and also have max measure of SumByClaim[ClaimNumber],SumByClaim[ClaimantID] to join in filter clause as per need. Think that as second table, you need to put join clause to match dates.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Serdia]

Thanks. But sorry, I didn't quite understand what do you mean? Do I need to group by in my FILTER?