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