Wrong Total Line

DAX DAX Calculations
1

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.

image
image.png761×500 31 KB

2

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.

Enjoy

Enterprise%20DNA%20Expert%20-%20Small

3

Thanks I will check that out shortly.

4

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