Forum Discussion
Direct Queries Multiple Semantic Live Models Measures
I am having issues using Dax formuales measures between two direct query feeds.
One is for Spend related on project, and the other query is for scoring the performance of a project.
Both can show values directly taken from the it shows a value but when using both tables on same page if get one showing and one cannot. both have same date and are linked by unique client number.
The DAX measure below to give the % will not display within the graph, but will display as individal card.
Shows the card is working but just will not show in the graph.
Spend is working
Error message below
Hi, JohnnyT48
This error typically occurs when there is a problem with the DAX formula or query structure. First, check if there are any issues with your DAX expressions. Check that the data type in the DAX formula matches the data type in the table.
Make sure that the relationships between tables in the data model are set up correctly. As mentioned earlier, both tables should be linked by a unique client number, but it's worth double-checking that this relationship is active and properly configured. You can check the following link:
Model relationships in Power BI Desktop - Power BI | Microsoft Learn
Check to see if there are any visual-level filters or interactions that might prevent the measure from displaying correctly in the graph. Sometimes, a specific configuration in one visual can affect how data appears in another visual. Performance Analyzer in Power BI Desktop can help you diagnose any performance or rendering issues with your visuals:
It's also possible that some DAX functions aren't compatible with direct queries. If you're using DirectQuery for both data sources, consider whether your scenario requires a composite model. Composite models allow you to combine DirectQuery and import data sources, which may help with issues related to cross-query calculations. You can check the following document:
Use composite models in Power BI Desktop - Power BI | Microsoft Learn
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.
1 Reply
Hi, JohnnyT48
This error typically occurs when there is a problem with the DAX formula or query structure. First, check if there are any issues with your DAX expressions. Check that the data type in the DAX formula matches the data type in the table.
Make sure that the relationships between tables in the data model are set up correctly. As mentioned earlier, both tables should be linked by a unique client number, but it's worth double-checking that this relationship is active and properly configured. You can check the following link:
Model relationships in Power BI Desktop - Power BI | Microsoft Learn
Check to see if there are any visual-level filters or interactions that might prevent the measure from displaying correctly in the graph. Sometimes, a specific configuration in one visual can affect how data appears in another visual. Performance Analyzer in Power BI Desktop can help you diagnose any performance or rendering issues with your visuals:
It's also possible that some DAX functions aren't compatible with direct queries. If you're using DirectQuery for both data sources, consider whether your scenario requires a composite model. Composite models allow you to combine DirectQuery and import data sources, which may help with issues related to cross-query calculations. You can check the following document:
Use composite models in Power BI Desktop - Power BI | Microsoft Learn
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.