Forum Discussion
Total Count Without Duplicates
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 can see in pic 4th rows (Yellow Highlighted) has count value 2 insted 1. Total count of table should be 5 insted 6.. Please guide me how can i calculate the right count.
12 Replies
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?
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
Hi vishalbaldania,
Could you please mark the proper answer as solution if it's convenient for you? That will be a help to the others.
Best Regards!
Dale
