Power Bi Report Builder DAX Result different from DAX studio

Hi, Lahryco 

Possible causes, DAX Studio executes queries against the dataset directly, while Power BI Report Builder relies on paginated reports. The latter may introduce differences due to its specific context and rendering requirements. 

Ensure that the relationship between Table Ligne[OASIS_Perimeter] and other tables is correctly defined in your Power BI model.

You can also double-check the measures and filters used in your DAX queries. Differences in filtering or calculations can lead to different results. Investigate any changes made to the data model or dataset after September 7, 2024. Changes in data or relationships can affect the results.

If possible, compare DAX query results directly in Power BI Desktop, which provides more advanced reporting capabilities, to identify any discrepancies. Consider using DAX Studio to debug and explore your data model, and then tune your queries for use in Power BI Report Builder.

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.