Specific Columns Total Combined

[Roger_M]

How do I add the total of several specific columns and create a visual to display it?

I selected on the Visual Values to have the Totals displayed.  Now I need to sum only specific totals of these columns and I would like to display that as a grand total on a different visual.  Please help. 🙂

[V-yubandi-msft · Accepted solution]

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.

[Roger_M]

Hi @V-yubandi-msft ,

I just got back to my computer and will try to place your solution in my dashboard, but I am not sure where you placed the calculations, in a cell or a visualization, it appears you created extra columns?   Please advice, I am pretty novice with PBI.  

[V-yubandi-msft · Accepted solution]

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.

[Roger_M]

@V-yubandi-msft , thank you so much for your help.  After I placed my last question I thought about this "New Measure" you provided the instructions for.  I have not used much Dax lenguage on my PBI dashboards until now.  I will start to learn more.

Thank you again!!

[V-yubandi-msft · Accepted solution]

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.