Forum Discussion

Digger's avatar
Digger
Icon for Post Patron rankPost Patron
5 years ago

Countr rows exporte to csv

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)
Need Help
Show and Tell
Tips and Tricks
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
5 years ago

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's avatar
Digger
Icon for Post Patron rankPost Patron
5 years ago

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's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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.