Forum Discussion
Helper IIIFabric Notebook not performing calculations on some data in a semantic model
In case anyone comes across the same issue, I had a call with a Microsoft agent and he suggested using the following code in my notebook before performing any functions:
fabric.refresh_dataset(dataset="your_dataset", workspace="workspace_name")It has been working so far. Hope this helps!
Hi Neka ,
Thank you for reaching out to us on Microsoft Fabric Community forum.
If the measure [Gross Sales] returns BLANK(), the corresponding row is excluded from the results.To address this, you might modify the measure in the Semantic Model using the COALESCE function:
Gross Sales = COALESCE([Gross Sales], 0)
This may ensures that even if there is no sales data for a specific Source, Date, and Customer combination, the measure returns 0 instead of BLANK(), thus including the row in the output.
Refer the link for detailed understanding
If this post helps, please give us Kudos and consider Accept it as solution to help the other members find it more quickly.