The sum of rows pr column

Question

Hey,&nbsp;I am new user and I wonder how to write a DAX-code to get the sum (Hours totally) of each column based on periods 202401, 202402, etc... I tried with sum and filter but it didn't work.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

greg_deckler · Answer

alissska24&nbsp;First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742eThis looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907Also: https://youtu.be/uXRriTN0cfYAnd: https://youtu.be/n4TYhF2ARe8

anonymous · Answer

Hi,
Thanks fot the solution&nbsp;Greg_Deckler&nbsp; provided, and i want to offer somre more information for user to refer to.
hello&nbsp;alissska24&nbsp;, based on your descriotion, you can refer to the following solution.
Sample data&nbsp;

&nbsp;
1.IF you just want to display the total, you can put the data to a matrix visual, it can display the total.

&nbsp;

&nbsp;
2.You can create a measure
MEASURE =
CALCULATE (
    SUM ( 'Table'[Planlagt] ),
    ALLSELECTED ( 'Table' ),
    'Table'[Period] IN VALUES ( 'Table'[Period] )
)

Output

&nbsp;
Best Regards!
Yolo Zhu
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

alissska24 · Answer

Thank you! And how can I make a table at dashboard that will show this when I have data as table and as measuer? And the last row (Resources needed) suppose to be 'divide' function.

anonymous · Answer

Hi&nbsp;alissska24&nbsp;
Thanks for your quick reply, you can refer to the following solution.
Sample data&nbsp;

1.Create a 1:N relationship between tables

&nbsp;
2.Create the following measures
TotalHours = SUM('Table'[Planlagt])Hour per month = SUM('Table (2)'[Verdi])Resource needed = SUMX(VALUES('Table (2)'[Period]),DIVIDE([TotalHours],[Hour per month]))
Then put the period field of the table(2) and the measures to the table visual.

Output

&nbsp;
&nbsp;
&nbsp;
Best Regards!
Yolo Zhu
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

alissska24 · Answer

Thanks. It worked very well. I managed to make capacity column as well, but when I add it to the diagram I get only flat line. What is missing?&nbsp;&nbsp;&nbsp;