How do we show TOTAL number of rows in a table based on created date

[Anonymous]

I am completely a newbie to powerBI. I have a simple table with a "ID" and "CREATED_ON" fields.

I want to create a visualization that shows, the total number of rows in the table based on the "CREATED_ON" field.

The COUNTROWS(TABLE) Displays the records that were created on that particular date. but it does not show the total records including previous dates as well.

[Ashish_Mathur]

Hi,

Try this approach:

1. Create a Calendar Table and build a relationship from the CREATED_ON field of your base data table to the Date column of your Calendar Table
2. To your slicer, drag Date from the Calendar Table and select any one date there
3. Write these measures

Measure1 = COUNTROWS(TABLE)

Measure1 running total = CALCULATE([Measure1],DATESBETWEEN(Calendar[Date],MINX(ALL(Calendar),Calendar[Date]),MAX(Calendar[Date])))

Hope this helps.

[Anonymous]

Hi @Anonymous,

What type of count you mean? The current 'create on' fields row count or the cumulative row count that less than or equal to the current row?
If you mean the current row count, you can create a table visual with two 'create on' fields, one used as category and setting to 'do not summary' the other use aggregate mode 'count'.
If you mean cumulative row count, you can create a measure formula with AlB's formula.

Regards,

Xiaoxin Sheng

[AlB]

Hi @Anonymous 

If you want to show for each date the number of rows in the table with that or or a previous date, you can:

1. Place Created on in the rows of a matrix visual

2. Place this measure in the matric visual 

Measure =
CALCULATE (
    COUNT ( Table1[Created_On] ),
    FILTER (
        ALL ( Table1[Created_On] ),
        Table1[Created_On] <= MAX ( Table1[Created_On] )
    )
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

 Cheers