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

6 Replies

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    Digger 

     

    Can you please add more details to your question?

    Do you want to export Table Data?

     

    Appreciate your Kudos ✌️ !!

  • 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.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    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.