Forum Discussion

Mouseman85's avatar
Mouseman85
Icon for Helper I rankHelper I
2 years ago

Simple SUM of a column not adding correctly

Hi, I have an issue where the total on a table visual is not adding correctly when a date range slicer is applied, but when export the table visual as a CSV the totals are correct ; the...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Confirm that the three filters are present in both queries

 

VAR __DS0FilterTable = 
		FILTER(
			KEEPFILTERS(VALUES('DateTable'[Date])),
			'DateTable'[Date] < DATE(2023, 10, 1)
		)

	VAR __DS0FilterTable2 = 
		TREATAS({"Balance Not Raised"}, 'SaleSheet'[Fully Invoiced])

	VAR __DS0FilterTable3 = 
		TREATAS({"active",
			"completed",
			"reconciled",
			BLANK()}, 'SaleSheet'[Project Status])
Mouseman85's avatar
Mouseman85
Icon for Helper I rankHelper I
2 years ago

that still doesn't explain that why when it filters the results left don't add up correctly in the total, but when you manually add up the numbers using a calculater they are different to what the the total in the SUM is showing?