Measure sum columns doesn't exist

[Anonymous]

Helllo 

My current measue is Sum(S1_101)+ Sum(S2_101)+Sum(S3_101). User will add S4_101,S5_101,S6_101 etc. How can I make my measure include new column automaticlly ?

Project	S1_101	S1_1012	S2_101	S2_102	S3_101	S3_102
A	100	200	150	300	600	400
B	100	200	150	300	600	400
C	100	200	150	300	600	400

[amitchandak]

@Anonymous , In such a case better to unpivot the data in power query and use that

https://radacad.com/pivot-and-unpivot-with-power-bi

[Anonymous]

Thanks for your answer, I can unpivot and split column, then caculate(sum(value),filter(table,New_code=101)). I am curious whether we can deal with by Dax

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

I doubt this can be done with DAX. You can manually add new columns in the measure that need to be summed.

But if you Unpivot the columns and then use the matrix to display the data, then it will be summed automatically.

Best Regards,
Community Support Team _ Zeon Zheng

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