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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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