PASS DATA COMMUNITY SUMMIT 2021 – Links AND REFERENCES

Reading Time: 2 minutes

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

DAX GUIDE to USERELATIONSHIP

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 DAXMatt 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 to CROSSFILTER

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

Non-Numeric Measures

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!

2 comments

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

Leave a Reply

Your email address will not be published. Required fields are marked *