Forum Discussion

Digger's avatar
Digger
Post Patron
4 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
Community Support
4 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
    Post Patron
    4 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
      Community Support
      4 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.