Forum Discussion

vishalbaldania's avatar
vishalbaldania
Helper I
9 years ago

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...
Need Help
vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

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

vishalbaldania's avatar
vishalbaldania
Helper I
9 years ago

vanessafvg

 

Could you please tell me formula for count of all rows in the table. becasue i want to use that as KPI

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    9 years ago

    vishalbaldania counting all rows is simply countrows(tablename)

    • vishalbaldania's avatar
      vishalbaldania
      Helper I
      9 years ago

      vanessafvg

       

      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's avatar
        vanessafvg
        Community Champion
        9 years ago

        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?