DAX can get complex and humble even experienced BI developers. Since Microsoft left us without a proper debugger, here a couple of techniques that I use to debug DAX when going gets tough:
Read on for two things you can do to get a better understanding of what’s going on with your DAX measures.