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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.