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 unfortunately with this limited information i would need to be a bit psychic to understand the issue :womanvery-happy:

 

as i said i need a screen shot of your relationships if you are using more than one table?

can you also post how you did your measures, the code?

  • vishalbaldania's avatar
    vishalbaldania
    Helper I
    9 years ago

    vanessafvg 

     

    Formula for Column: Column = COUNT(RPT_COMEBACKS[Equipment ID])

     

    Formula for Measure: Measure = COUNTROWS(RPT_COMEBACKS)

     

     

     

     

    • 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