cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
EdwardXAult Frequent Visitor
Frequent Visitor

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 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

1 ACCEPTED SOLUTION

Accepted Solutions
EdwardXAult Frequent Visitor
Frequent Visitor

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

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

 

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

View solution in original post

4 REPLIES 4
v-jiascu-msft Super Contributor
Super Contributor

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

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
EdwardXAult Frequent Visitor
Frequent Visitor

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

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

 

desired output.jpg

v-jiascu-msft Super Contributor
Super Contributor

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

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
EdwardXAult Frequent Visitor
Frequent Visitor

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

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

 

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

View solution in original post

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 171 members 1,773 guests
Please welcome our newest community members: