Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
sorry, my problem description was only half my challenge, I found this reference that talks to exactly the problem.
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
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
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
sorry, my problem description was only half my challenge, I found this reference that talks to exactly the problem.
User | Count |
---|---|
124 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |