topic Sum of multi columns and should display individual columns based on selection. in DAX Commands and Tips

Sum of multi columns and should display individual columns based on selection.

Anonymous — Wed, 17 Apr 2024 15:28:31 GMT

Hi All.
I summed 4 columns of data using the SUMX function

test = CALCULATE(SUMX('Table','Table'[Dad] +'Table'[daddid]+'Table'[did]+'Table'[not]))

how to craete dropdwon with four column headers, if i select any one column header from dropdown. the total shpuld upadte with select column.

if i select DAD from dropdown the toatl should be 34
if i select NoT from dropdown the toatl should be 32

Re: Sum of multi columns and should display individual columns based on selection.

tamerj1 — Wed, 17 Apr 2024 17:28:00 GMT

Hi Anonymous

Easiest way is to unpivot the four columns in power query hense the column names would appear as values in the [Attribute] column therefore you can use it as filter.

Re: Sum of multi columns and should display individual columns based on selection.

Anonymous — Thu, 18 Apr 2024 03:14:49 GMT

Hi Anonymous

Just as tamerj1 said that you can unpivote the 4 column, here are detailed step:

First of all, select the four column and unpivote then in power query.

Then add a measure:

Measure 2 = SUM('Table (2)'[Value])

The result is as follow:

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.