Only way I can think of is writing custom SQL or using the COUNTD function. You could also do this in Tableau Prep.
Why are you trying to avoid duplicate records? What's the use case? What's driving the requirement?
In addition to suggestion provided by Ken, you can apply min or avg function on your measure to avoid incorrect result.
Thanks for the input...after applying Avg function on measure value, I can
get the distinct value, but when I do the grand total, it s shows average
instead of Sum ... I want the sum of distinct value..
On Sun, Jun 10, 2018 at 10:08 PM, Tushar More <email@example.com>