Wrong Total Line

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

1 Like