Specific Columns Total Combined

Hi Roger_M ,

Thank you for engaging with the Microsoft Fabric Community. I tried to reproduce your requirement and was able to achieve it successfully.
I've attached a screenshot for your reference, and also included the DAX measure I used to get the correct result.
FYI:

User Measure:

TotalSpecificColumns = 
    SUM('Table'[Scaff Removed to grade]) +
    SUM('Table'[Rope ET to Grade]) +
    SUM('Table'[Rope UT to grade]) +
    SUM('Table'[Rope UTs to grade])

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

Hi Roger_M ,

Create a new measure in Desktop by following these steps: Go to the Home tab---click on the Modeling tab--- select New Measure -----  paste the measure I mentioned, and click OK.

For more details, I have attached a PBIX file with sample data. Please refer to the PBIX file.

Did I answer your question? Mark my post as a solution.