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

[EdwardXAult]

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 files; multiples allowed). Need a crosstab presentation (i.e. Matrix visualization) with w/ category A elements as rows and category B elements as columns.  Thoughts?

file_tags layout:

tag_id    tag_name     category

1            Apple           Fruit

2            Banana         Fruit

3            Kiwi              Fruit

4            Mango         Fruit

5            Orange        Fruit

6             Breakfast      Meal

7            Brunch          Meal

8            Meal             Meal

9            Dinner           Meal

[v-jiascu-msft]

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]

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]

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?

Best Regards,

Dale

[EdwardXAult · Accepted solution]

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

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