Forum Discussion
Power BI table sum
Hi Learner_SG ,
1. Here are many methods to calculate the sum.
- Change the summarize type ——Hour:Don't summarize ; Usage: Sum:
- Create a measure
Measure = CALCULATE(SUM('Table'[usage]),FILTER('Table',[hour]=MAX('Table'[hour]))) //or //CALCULATE(SUM('Table'[usage]),ALLEXCEPT('Table','Table'[hour]))- Create a column:
Column = CALCULATE(SUM('Table'[usage]),FILTER('Table',[hour]=EARLIER('Table'[hour]))) // or //CALCULATE(SUM('Table'[usage]),ALLEXCEPT('Table','Table'[hour]))- Create a new table:
New Table = SUMMARIZE('Table','Table'[hour],"total usage",SUM('Table'[usage]))2. if I want to narrow it down for each day and hours, how should I modify the query?
What does "narrow down" mean? Can you please share more detail information to help us clarify your scenario?
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous , its the continuation of the question that I had asked previousl,becuase I am running into error now.
2. if I want to narrow it down for each day and hours, how should I modify the query?
What does "narrow down" mean? Can you please share more detail information to help us clarify your scenario?
What I mean is that I need to select the sum of usage for each hour in a DAY . now what happens is that it sums up all the usage of each hours from different days which is not I want. Could help me on it?
So assuming you have a Date column as well, try this calculated column formula
=calculate(sum(Data[usage]),filter(data,data[date]=earlier(data[date])&&data[hour]=earlier(data[hour])))
Hope this helps.