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:
Using disconnected slicers to calculate attrition (part 2) by Koen Verbeeck (@Ko_Ver)
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.
Multiple Relationships Between Tables in DAX – Matt Allington (@ExceleratorBI)
ExceleratorBI is another excellent resource for DAX queries, and this specific post focuses on the traditional application of role-playing relationships.
Bi-Directional Filters
dax.guide. Again.
The Wise Owl guide to CROSSFILTER
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.
Non-Numeric Measures
This is a favourite topic of mine, so have some of my links
Best In Class: A DAX Measure for Top Performers
Session Materials
Conclusion
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!
Thank you Sir for such a wonderful presentation and your kindness for giving us the slide deck and the PBIX file. I really appreciate this very much which will definitely help in my Power BI journey being a Finance Professional.
If you can, do a similar session for the “All about CONTEXT”, an some ALL, CALCULATE, ALLSELECTED, FILTER etc. I really enjoyed your session. You can send me the link if you have already similar session elsewhere. Thank you so much.
Rgds…Aziz
Thank you for your comment Aziz. I’m really glad you enjoyed the session. My session at last year’s PASS Summit was about the fundamentals of DAX Contexts. You can watch it here: https://youtu.be/xfif3cC3OiY