cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hombleu Visitor
Visitor

Cumulative count of rows

Hi guys,

 

Maybe someone could help me with this issue..

I've made a connection with MYSQL db in Power BI. The db rows are based on daily base. So I've already created a countrows measure to count the rows per day. But now I'm looking for a cumulative measure of the rows per day.

 

So the rows per day can be counted in a cumulative way.

2 REPLIES 2
jPinhao Regular Visitor
Regular Visitor

Re: Cumulative count of rows

You have to calculate the sum of the value while filtering by all dates before the current MAX - current as in the current context, which will be the the day in a bar chart with a date on the axis for instance:

 

Cummulative = CALCULATE (
                     [number]
                     FILTER ( ALL([Date]), [Date] <= MAX([Date]) )
              )
v-haibl-msft Super Contributor
Super Contributor

Re: Cumulative count of rows

@Hombleu

 

Please follow the solution provided by jPinhao, you should only need to do small change to formula if you want to get the cumulative rows – replace [number] with your countrows measure.

 

cumulative = 
CALCULATE (
    [countrows],
    FILTER ( ALLSELECTED ( Table1 ), Table1[Date] <= MAX ( Table1[Date] ) )
)

Cumulative count of rows_1.jpg

 

Best Regards,

Herbert