sum row by row

2 Topics

How to sum numbers in the row as many as the numbers in a column
Hi my friends, Please help me, I want to add column in tabel. How to sum numbers in the row as many as the numbers in a column. Here is the data sample and my expected result in last column. I want to sum up item 1 until item 10 as many as 8 in row 1 Passage_item Item 1 Item 2 Item 3 Item 4 Item 5 Item 6 Item 7 Item 8 Item 9 Item 10 Result 8 1 0 1 0 1 1 0 1 0 1 5 9 1 1 0 1 1 0 1 1 0 1 6 9 1 1 1 1 1 1 1 1 1 1 9 10 1 0 1 0 1 0 1 0 1 1 6 10 1 1 0 0 1 1 0 1 1 1 7 Thanks for Help
Solved
LA_Enjoy
3 years ago Place DAX Commands and Tips
1KViews
0likes
5Comments
Sum Row by Row and Bin values into groups
Hi, I have a raw data set where there are multiple lines for each Project ID and Country. I then grouped this data by Project ID & Country (Market), and aggregated all NTSLC$ values. This is my "Proj Aggregation Test" table in powerBI. However, when I create a table in PowerBI, and put the financials, it is giving me the TOTAL value instead of the sum of each line item (eg. first row should be the total financials of the 2 projects in that bin) How do I write a DAX to sum only the rows???
Solved
Anonymous
3 years ago Place DAX Commands and Tips
1.2KViews
0likes
3Comments