How to do a row count before any ETL is applied

[PPStar]

Hello. 

I have a table which has lotw of merges. I want do a row count BEFORE all the merges.  How can i acheve this ?
Ideally, if we could do a row count on an applied step, then i could just do a row Count on a step, but i dont think this is possible. 

I tried to add a step BEFORE all the merges steps, this worked, but then when i clicked on the merge step after, I  got an error about unable to convert value to a table or something. 

[danextian · Accepted solution]

hi @PPStar 

It depends on the kind of row count you want - count by summarizing the table or count by creating a custom column.
Custom column:

Summarized Table

Grouping all rows as a table without aggregation and then counting the rows of each table in the Grouped column

Please see the attached sample pbix.

[danextian · Accepted solution]

hi @PPStar 

It depends on the kind of row count you want - count by summarizing the table or count by creating a custom column.
Custom column:

Summarized Table

Grouping all rows as a table without aggregation and then counting the rows of each table in the Grouped column

Please see the attached sample pbix.

[Ilya_K]

Maybe this will help.

Select Column Profile in View Section.

Make Column profiling based on entire dataset

Select any column and make sure you are on desired step.

[PPStar]

Thanks. 

I need to store this value as a measure..  Is that possible?

[Anonymous · Accepted solution]

Hi @PPStar 

As a alternative workaround, maybe you can try to use the COUNTROWS() function to store this value as a measure:

COUNTROWS function (DAX) - DAX | Microsoft Learn

By the way, if this result is incorrect in the next steps, you can duplicate the table, then delete the subsequent steps and use measure to count.

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.