Hi there, I have a few knock-on Measures. In the same table, all the preceding calculations are working out the totals correctly. When I get to the last knock on calculation the figure doesn’t total correctly. I know this has something to do with context, but i can’t figure out why all the preceding measures are accurate except for one. Please help. There are a lot of zeros. I have tried, hasonefilter and tried the sumx to add the selected months in the filter. Help wonderful Community
Test.pbix (460.3 KB)
Data.xlsx (29.4 MB)
Hi @SammiP,
While waiting for the community to review and respond to your issue, take advantage of Data Mentor. It offers a wealth of tools and resources that could provide immediate solutions and enhance your report-building efficiency.
Cheers,
Enterprise DNA Support Team