I have a metric : Exhibitors = DISTINCTCOUNT(Details[Exh ID]) the individual rows in the tables are correct but the TOTAL line at the bottom is wrong.
Same has great content regarding this in his YouTube & Training content here at Enterprise DNA. Probably going to need to use the SUMMARIZE function to get the Totals at the bottom to be correct. Here is a link to the video.
Thanks I will check that out shortly.
Thank you for posting that YouTube video - I created a summary table as described in the video and it worked like a charm