topic DAX Code to sum columns in DAX Commands and Tips

DAX Code to sum columns

squizzonk — Tue, 17 Jun 2025 17:56:06 GMT

Very new to DAX, trying to sort out this issue to sum multiple columns and rearrange how it's presented:

The table structure that I currently have:

Name	Product A	Product B
Person 1	1	2
Person 2	1	1

Result I'm looking to get:

Product	Sum Amount
Product A	2
Product B	3

Would this be achieved by a combination of new measures? Any help super appreciated

Re: DAX Code to sum columns

squizzonk — Tue, 17 Jun 2025 17:59:24 GMT

Think the formatting messed up

First Table

Name Product A Product B

Person1 1 2

Person2 1 1

Result looking for:

Product Sum Amount

Product A 2

Product B 3

Re: DAX Code to sum columns

techies — Tue, 17 Jun 2025 20:37:14 GMT

Hi squizzonk you can simply select the Product A and Product B columns in Power Query and use the Unpivot selected columns option

Re: DAX Code to sum columns

v-sgandrathi — Wed, 18 Jun 2025 06:46:53 GMT

Hi squizzonk,

I Started by clicking "Enter Data" and created a simple table with columns: Name, Product A, and Product B. After loading the table, navigate to Power Query Editor by selecting "Transform Data" from the Home ribbon. In the editor, select both "Product A" and "Product B" columns while holding Ctrl, then right-click and choose "Unpivot Columns". Rename the resulting "Attribute" column to "Product" and the "Value" column to "Amount". Click "Close & Apply" to return to Power BI. In the report view, insert a Table visual and drag the Product and Amount fields into the visual. Power BI will automatically summarize the Amount by each Product.

I have included the PBIX file that I created using the provided sample data. Kindly review it and confirm whether it aligns with your expectations.

Thank you and comtinue using Microsoft Fabric Community Forum.

Re: DAX Code to sum columns

mark_endicott — Wed, 18 Jun 2025 11:18:11 GMT

squizzonk - You need to unpivot this data, here's an article from me on why / how: https://triangle.im/power-bi-mistake-5-why-pivoted-data-leads-to-power-bi-pain/

If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!

Re: DAX Code to sum columns

squizzonk — Thu, 19 Jun 2025 17:16:37 GMT

Thanks much!!