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...
Formula for Column: Column = COUNT(RPT_COMEBACKS[Equipment ID])
Formula for Measure: Measure = COUNTROWS(RPT_COMEBACKS)
vishalbaldania so are you wanting a unique count of equipment id, or just a count of all the rows in the table?
Formula for Column: Column = distinctCOUNT(RPT_COMEBACKS[Equipment ID])
Formula for Measure: Measure = distinctCOUNT(RPT_COMEBACKS)
this is for unique count