DAX - How do i get rows count from the result set ??

[Anonymous]

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

[SivaMani]

Please do refer the below DAX function,

https://msdn.microsoft.com/en-us/query-bi/dax/count-function-dax

[Anonymous]

@SivaMani i need overall records count. Like we have in SQL

Select Count(*) from TableA Group by ColumnA

[v-jiascu-msft]

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

[Anonymous]

Hi @v-jiascu-msft,

I have three tables with those tables i am doing the group by.

If i am using the CountX function i need to specify only one table then the result will be wrong.

[v-jiascu-msft]

Hi @Anonymous,

How did you do "Groupby" for now? The first parameter of COUNTX is a table expression, which means we can put a expression that returns a Table. Can you share a sample?

Best Regards,

Dale

[Anonymous]

Hi @v-jiascu-msft,

Please check the below query, 

EVALUATE
SUMMARIZECOLUMNS(
Table1[ColumnA],

Table1[ColumnB],

Table2[Column2],

Table3[Column4],
FILTER(VALUES(Table1[ColumnA]),Table1[ColumnA]="ABC"),
"Total",SUM(Table1[CreditAmount])
)

[Anonymous]

EVALUATE

ROW("count",

COUNTROWS(
SUMMARIZECOLUMNS(
Table1[ColumnA],

Table1[ColumnB],

Table2[Column2],

Table3[Column4],
FILTER(VALUES(Table1[ColumnA]),Table1[ColumnA]="ABC"),
"Total",SUM(Table1[CreditAmount])
)))