Forum Discussion
How to count virtual Table rows
I'd like to count rows of virtual table which is made by some columns from some tables.
My image is here.
10 Replies
Anonymous not sure what you mean by virtual table, the measure should be
Row Count = COUNTROWS ( YourTable )parry2k
Thank you for your answer.But what I want to do is counting rows of new table which made by some columns from different table.
I don't know the name of "your table", becouse the new table don't have name.
Sorry for my poor explanation..
Do you get it?
Anonymous very hard to provide a solution without knowing the details. It will be easier if you share pbix file using one drive/google drive with the expected output. Remove any sensitive information before sharing.
Hi,
PBI file attached.
Hope this helps.
Anonymous you filtered on year and the data in the financials is at the date level, so it gives all the rows for the year you have selected in the slicer. In the bottom table, you are seeing data by year and month which is 4 months, but the count is by date. What do you want to see? Do you want to see the count by year and month?
Anonymous
As a best practice, add a date dimension in your model and use it for time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools. Check the related videos on my YT channel
Add Date Dimension
Importance of Date Dimension
Mark date dimension as a date table - why and how?
Time Intelligence PlaylistI used the date for the sample, but what I want to do is simply want to count the number of rows in the bottom table.
Could you fix my PBIX?
Should I use another DAX？
Anonymous there is nothing to fix, it depends on the business requirement, if at the bottom table you put the dates instead of year and month, it will show the correct count. So you have to define the business logic and then there will be solution based on it.
Anonymous and when I say business requirement, it includes how you want to visualize the data, at what granularity?
