Countr rows exporte to csv

[Digger]

How write mesure which will count how many rows will be exported to csv?

No one of existing agregation is not work (count, countrows, distinct, calculatetabe, summarize and etc)

[v-yalanwu-msft]

Hi, @Digger ;

Is the answer helpful to you? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @Digger ;

You could use summarize then countrows it , in addition ,it should +1 because header line.

For example:

1.if the visual field come from one table.

count1 = 
var _a=SUMMARIZE('Table',[ Category],[account name])
return COUNTROWS(_a)+1

2.if the visual field come from two table without relationship.

count2 = 
var _a=SUMMARIZE('Table',[ Category],[account name])
return COUNTROWS(_a)*COUNTROWS('new')+1

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Digger]

@v-yalanwu-msft  it is wrong

it not working on my example, it show 1009 rows but i got to csv 475 rows

[v-yalanwu-msft]

Hi, @Digger ;

It should be noted here that the values field is not in summarize, and then you try it.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VahidDM]

@Digger 

Can you please add more details to your question?

Do you want to export Table Data?

Appreciate your Kudos ✌️ !!

[Digger]

i want export visual data to csv