Forum Discussion
Total Count Without Duplicates
vanessafvg How to Count total number of rows in table after using some filter. I have created column and Measure to calculate number of rows in table but could not get right result. As you c...
Could you please tell me formula for count of all rows in the table. becasue i want to use that as KPI
vishalbaldania counting all rows is simply countrows(tablename)
As you said i used DISTINCTCOUNT(RPT_COMEBACKS[Equipment ID]) but the still output does not right (you can see in image). if you calculate total number of rows in table then it would be 9 insted 10.
I also used COUNTROW: Measure = COUNTROWS(RPT_COMEBACKS) but result is not changed.
vishalbaldania why are you creating a column? they should both be measures
just so that i understand what you trying to do.
you want to see the total rows in the table vs the count of unique equipment id's?
YES that's right