Forum Discussion
vishalbaldania
Helper I
Helper ITotal 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...
vishalbaldaniaHelper I
Helper I
Could you please tell me formula for count of all rows in the table. becasue i want to use that as KPI
vanessafvg
Community Champion
Community Championvishalbaldania counting all rows is simply countrows(tablename)
- vishalbaldania
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.
- vanessafvg
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?
- vishalbaldania
YES that's right