This is a companion article to my talk, “DAX Safari – 4 Useful DAX Solutions for Business Problems”. It includes some links to documentation, the slide deck, and the PBIX file used in the demos.
Disconnected Range Slicers:
A few years ago I asked for some advice on Twitter about a problem I was having with a disconnected slicer, and Koen graciously helped me understand the problem, and then turned it into a two-part blog. This has more detail than I could ever supply in a session. The actual range on range slicer we looked at is in part 2.
Strangely, there is not a huge amount of other documentation around this topic, or if there is, I can’t find it. Plenty of examples of disconnected slicers, but most are using the range in the disconnected table, rather than the fact table. I will definitely have to write something soon!
Role Playing Relationships
There isn’t really much to say about the work of Marco and Alberto, except to bow down in adulation. dax.guide is just the latest example of their contribution. There is no better place to find documentation on DAX. Period.
ExceleratorBI is another excellent resource for DAX queries, and this specific post focuses on the traditional application of role-playing relationships.
This is an excellent article explaining the perils of bi-directional relationships in a data model, and why CROSSFILTER is an excellent way to handle the scenario.
This is a favourite topic of mine, so have some of my links
Thanks for attending the talk, or just popping by. Hope that you have found something useful, and you can use some of these tips in your day-to-day work!