Sorry, error while retrieving data for this visual element

Hello Olufemi7 , 

Thanks for the detailed answer. I tried this:

Total Temps Boond = 
SUMX(
    FILTER('CRA Business One', ISNUMBER('CRA Business One'[Temps passé (J)])),
    'CRA Business One'[Temps passé (J)])

And it did not work for me.

I think the fact that I am using a composite model and that this column comes from a cloned table of a direct query table might play a role in this.

For now, I just resorted to using the column itself in the report.

Thanks for your help.

Best regards.

Hi Girl_that_works, 

Thanks for sharing that!

You're absolutely right composite models, especially when you're working with cloned tables from DirectQuery sources, can introduce some quirks in how DAX behaves.

Functions like SUMX and FILTER don’t always evaluate as expected when the column comes from a DirectQuery path. 

Using the column directly in the report sounds like a smart workaround for now.

If you ever revisit the model setup, switching that table to Import mode or using a calculated table might give you more flexibility with your measures.

Microsoft has a solid breakdown of how Import, DirectQuery, and Composite modes work in the Power BI Service definitely worth a look if you're digging deeper into model behavior.

Power-BI/connect-data/service-dataset-modes-understand 

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models 

Happy to help anytime if you want to explore other options or troubleshoot further!

Best,

Olufemi

Hi Girl_that_works 

Since you mentioned you are using composite model, Please make sure this setting is enabled in you tenant
Allow DirectQuery connection to Power BI semantic models.
Export and sharing tenant settings - Microsoft Fabric | Microsoft Learn

I hope this information helps. Please do let us know if you have any further queries.
Thank you