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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

Sum function is not working in MS Fabric





Hello, I have 'Hours' column in fact table with data typeas 'Whole Number'. I have written measure in MS Fabric as 'Total Hours' as  SUM fact_data['Hours'] as Whole Number . But when I try to use this measure in Report itis showing error. This is same case with other  column as well . Please help me to resolve this issue. Please find attached screenshot for reference.

Super User
Super User

hello there is no file and what is the error

I have paste screenshot in question itself.

Yes but i need to see the full error not the display that there is an error please so on yje visual press see detail please

doubt 4.PNG

Hi @Dipesh123 ,

Since your fact table is in dual mode, maybe the query for your card visual is hitting the direct query partition and this returns an error. The cause can very much depend on your backend architecture. If it is file based data lake then a frequent problem is that the structure or data types in a row of a file does not match with the column definitions of the SQL endpoint on top of it. The direct query partition migth also be linked to an on premise or any other kind of data source that is currently not available or reachable. Would you like to share some information about your data backend architecture, your dual mode table setup, and the filter context that is applied to the failing card visual?

Alternatively, you could just try switching the tables to import mode to see whether the problem comes from data source access or from within your data model. Or you could set a filter on the card visual that prevents from accessing the direct query partition to check for this being the root cause or not.



Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.