Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
djdave022002
Frequent Visitor

Column in Table Will not SUM, COUNT or do anything

Hi, i have created a large report which works almost perfectly, except one column. I have multiuple data sources which are all tables in the same same AccessDB, i have one column which contains whole numbers and i cannot perform any form of calculation on it and its driving me insane as it did work at one point. I have checked the column type is Number in Query editor and in Access and it only contains numeric data with no filters applied. What am i doing wrong ???

1 ACCEPTED SOLUTION
djdave022002
Frequent Visitor

UPDATE: I removed and re-added the data source and it worked - No Other Changes ... Very annoying but mut have bcorrupted in some fashion.

View solution in original post

1 REPLY 1
djdave022002
Frequent Visitor

UPDATE: I removed and re-added the data source and it worked - No Other Changes ... Very annoying but mut have bcorrupted in some fashion.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors