Issue when tally Total in a column using DAX

Hi tony-G_2020 ,

Try breaking it into two steps. That should work.
New table:

Table =
VAR _Result =
    CALCULATETABLE (
        SUMMARIZE (
            FILTER (
                FI_Details,
                FI_Details[Framework] = "A"
                    && FI_Details[Membership_Capacity] = "IA"
                    && FI_Details[Status] = "Active"
                    && FI_Details[startMergedDate] = "-"
                    && FI_Details[startMergingDate] = "-"
                    && FI_Details[startInactiveDate] = "-"
                    && FI_Details[period] = "JUL22 - JUN23"
            ),
            FI_Details[Code],
            FI_Details[period],
            "Total VOL", CALCULATE ( [Total VOL] )
        )
    )
RETURN
    _Result

 New calculated column:

Indusrtry Total VOL = SUM('Table'[Total VOL])

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group