Forum Discussion
DAX - How do i get rows count from the result set ??
Hello,
I have 3 tables which are all linked to each other.
Now i am doing group by which includes all the 3 table columns and it returned some records.
Now i want the result set records count. How do i get that. Please help me..
7 Replies
SivaManiResident Rockstar
Please do refer the below DAX function,
https://msdn.microsoft.com/en-us/query-bi/dax/count-function-dax
SivaMani i need overall records count. Like we have in SQL
Select Count(*) from TableA Group by ColumnA
v-jiascu-msftMicrosoft Employee
Hi Anonymous,
How did you group the tables? Please try the function "COUNTX". Reference: query-bi/dax/countx-function-dax. It could be like below.
Measure = Countx([Groupby table], [to count column name])
Best Regards,
Dale