Matrix in Direct Query - String measure

[Krijztian]

Hi,

I have done a Power BI report using Import that shows a production overview as below - giving the status per workshop as the measure. This is done using a string column called "Status Label", and thus an implicit measure called "First Status Label". Works exactly as intended.

Not I want to reproduce said report in Direct Query, in order to get a more frequent refresh. Same setup, same tables, only differences is DQ and not Import. Results as below.

What is going on? And how may I work around it?

[Krijztian · Accepted solution]

Thanks for reaching out. The measure is just a text string, as such it is not calculated, but simply an implicit measure of first "Label".

However, I found the error, which was in the relations mapping that apparently had taken a different direction on two of my relations than in the import model.

[MFelix]

Hi @Krijztian ,

Without any information about on the measure is calculated is difficult to give you the correct answer.

Can you please provide what is the measure you are refering?