Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Matrix in Direct Query - String measure

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?

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
    MFelix
    Super User
    4 years ago

    Hi Anonymous ,

     

    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?