Sum function is not working in MS Fabric

Question

&nbsp;&nbsp;Hello, I have 'Hours' column in fact table with data typeas 'Whole Number'. I have written measure in MS Fabric as 'Total Hours' as&nbsp; 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&nbsp; column as well . Please help me to resolve this issue. Please find attached screenshot for reference.

eliasayyy · Answer

hello there is no file and what is the error

anonymous · Answer

I have paste screenshot in question itself.

eliasayyy · Answer

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

anonymous · Answer

martin_d · Answer

Hi Anonymous&nbsp;,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.BRMartin

Forum Discussion

Sum function is not working in MS Fabric

5 Replies

Related content

Fabric User Define Functions

Fabric Trial not working

user data function in fabric

Fabric Data Agent Tool not working

Cannot connect to Fabric Lakehouse SQL endpoint from Azure Function App (MSI) — works locally