Create a measure to show Row Count in Table Visualiation

Question

Hi&nbsp;I am trying to create a measure which should show row count in a table visualization. Columns in the visualiation are from 4 different tables.&nbsp;I tried to use COUNTROWS(SUMMARIZE(Table 1,Table 1[Column],.......)) DAX function. This function is showing columns from only 2 tables and it is not showing the columns from other 2 tables.&nbsp;One more additional question is, I also have a couple of measures in the visualization. Is it possible to add measures to the DAX function or it will not make any impact ?&nbsp;How should I create that measure to show row count in a table visualization.&nbsp;Thanks

nathaniel_c · Answer

Hi&nbsp;Anonymous&nbsp;&nbsp;Try SELECTCOLUMNS()&nbsp;If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.Nathaniel

anonymous · Answer

Hi&nbsp;Nathaniel_C&nbsp;Thanks for the suggestion.&nbsp;I tried using SELECTEDCOLUMNS but it did not work.&nbsp;Any other suggestions...&nbsp;Thanks

v-lili6-msft · Answer

hi,&nbsp;Anonymous&nbsp;
Just use COUNTA Function create the measure for different table.
Then keep cross filter direction is "Both" for all the relationship.
If not your case, please share some simple sample data and your expected output.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
&nbsp;
Best Regards,
Lin

Forum Discussion

Create a measure to show Row Count in Table Visualiation

3 Replies

Related content

Need help creating a measure

Help to create DAX Measure

Create count measure

Create Measure to Return Highest Value

Creating new measure, only showing other measures