Forum Discussion
Specific Columns Total Combined
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. 🙂
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.
4 Replies
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 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.
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.
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!!
