Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |