Direct Queries Multiple Semantic Live Models Measures

[JohnnyT48]

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

[Anonymous · Accepted solution]

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:

Use Performance Analyzer to examine report element performance in Power BI Desktop - Power BI | Micr...

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.