I have a column where duplicate entry is there and while selecting KPI with count it is counting even duplicate values so can anybody let me know how to avoid duplicate values so that I can get a exact count.
Thanks & Regards
Add the DISTINCT keyword to your count function.
View solution in original post
Thanks Rob, it worked. Keep in touch as I am new to this.