Counts no of rows in calculated column with blank rows by DAX

[PijushRoy]

Hi Team,
I have sample data like this

Index	No Series
0	025010-025010
1	025132-025132
2
3
4
5
6	027019-027019
7
9
10
11	027086-027086
12
13
14
15
16
17

I need to create one new column with count of rows group wise (last column) by using DAX

Index	No Series	Need to count rows for each group
0	025010-025010	1
1	025132-025132	5
2
3
4
5
6	027019-027019	4
7
9
10
11	027086-027086	7
12
13
14
15
16
17

Thanks

[CNENFRNL · Accepted solution]

Weird, the index column is not contiguous. I correct it so that a simple FIRSTNONBLANKVALUE() does the trick.

[PijushRoy]

Hi @v-yalanwu-msft 

Please look into this requirement

[speedramps]

Hi  PijushRoy

Thanks for reaching out for help

Try this ..

In Power Query click on No Series and Fill.

This will popoulate the empty columns.

The create a DAX measre

Rowcount = COUNTROWS(yourtablename)

The on an emoty report canvas annd table visual with

• No Series
• Rowcount

  pPease click the thumbs up and accept solution button, thank you

[PijushRoy]

No, it will nor work @speedramps 
for Countrows for each row will generate only 1.