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

[Chari]

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

[tamerj1 · Accepted solution]

Hi @Chari 

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. 

[v-zhengdxu-msft · Accepted solution]

Hi @Chari 

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.

[tamerj1 · Accepted solution]

Hi @Chari 

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.