Dax help - to Calculate sum of Each Columns (I have 90 columns to be calculated)

[Anonymous]

I am fairly new to powerbi. I have the data with many columns. I need to get the sum of each columns as a table using dax.

I ll show a sample table here. (Original table has 90 columns like this and 500 rows)

OG1	OG2	OG3	OG4	OG5	OG6
118.54		1,513.64	396.00
79.38	1,190.65	393.60	17.43		486.02
1,135.72	486.02	69.42	525.00	79.38	856.97
189.45	856.97		1,190.65	1,135.72	105.23
396.00	105.23		486.02

I need the output like this:

Attribute	Sum
OG1	1919.09
OG2	2638.87
OG4	2615.1
OG3	1976.66
OG5	1215.1
OG6	1448.22

 Any help to write the dax measure for this would be great. 

[Greg_Deckler]

@Anonymous I would highly recommend unpivoting your columns in Power Query so that you end up with:

Attribute  Value

OG1         118.54

OG1         79.38

OG1         1,135.72

OG1         189.45

OG1         396.00

OG2         1,190.65

...

Then the problem can be solved with a by putting Attribute in a table visualization and a simple SUM of Value.