Forum Discussion
NUMBER OF REPORT RECORDS
Hello all,
how can I figure out the number of rows of records in a report?
so when i export the report, i know i export them all.
thank you
Zoey
7 Replies
Hi! You can create a COUNTROWS measure with DAX: COUNTROWS function (DAX) - DAX | Microsoft Learn
Also, when you export to Excel, if you are using a table or matrix and export with data with current layout the limit is 150K rows, so if you get the data exported and you click on a column and the count is over 150K (because of headers), your data is not all there. Ditto exercise if you choose to export using summarized data - but here your limit is 500K, so once it is exported, if you have more than 500K as the count, you don't have the full data.
audreygerred and Anand24
thank you both.. not for a particular table though: here is the situation:
i have parts table, trans table(left joint from parts), dates. i created measures say, purchase trans total, work orders trans total,
now i create a report for say 10 parts ( from parts), purchase trans total , work orders trans total, how can I know it is 10 total records in this report?
i created a countrows measure for parts table, it works fine by it own, but once i use it in the above report, it wont work since logicaly returns 1 and it is.
Create a countrows on your fact table and it will know the context of what you have filtered from your parts table to your fact table and return the count of rows in the fact table.
