Forum Discussion

EdwardXAult's avatar
EdwardXAult
Regular Visitor
8 years ago
Solved

Matrix Not Populating, measure, relationship or data model error?

looking for help understanding if I have a DAX measuring challenge or data model problem.  Example: three tables: recipes (name, file_id, date), tags (below), recipe_tags (which tags applied to which...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi EdwardXAult,

 

Can you share a dummy file of your data? It's easy to create a Matrix visual. So we won't know what the issue be without data.

 

Best Regards,

Dale

EdwardXAult's avatar
EdwardXAult
Regular Visitor
8 years ago

let me know if this link doesn't work; here's a visual to clarify desired output...the complication i'm struggling with is that all tag information is in one "Tag" table w/ columns of id, name and category i.e. I'm try to "cross" one filtered version of a column with another fitlered version of the same column....which has confused me if it's a data model or measure syntax challenge.

 

https://1drv.ms/u/s!AiWqzGWgz5Gmd6F10mYQbOuezAI

 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi EdwardXAult,

     

    Seems you don't need a measure. Just drag the 'file_tags'[file_id] in the Values field. Because they are in the same table and there is a relationship. Is the below what you need?

    Matrix_Not_Populating

     

     

    Best Regards,

    Dale

    • EdwardXAult's avatar
      EdwardXAult
      Regular Visitor
      8 years ago

      sorry, my problem description was only half my challenge, I found this reference that talks to exactly the problem.

       

      https://www.daxpatterns.com/survey/