The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
@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.
User | Count |
---|---|
26 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
32 | |
14 | |
10 | |
10 | |
9 |