Complex DAX measures

Creating measures in DAX can sometimes be complex if you don’t have a good understanding of certain functions or concepts. It can also be frustrating when you’re unsure how to implement a specific requirement within your report. However, some tricks can be very helpful in finding a solution for the measure you’re working on.

Complex model = complex measures

In previous sections, I mentioned that your data model will influence the complexity of your measures and, consequently, their results. For example, the following data model includes a calendar table and a table with sales records, specifically internet service sales. As you can see, three relationships are established between these tables, although Power BI only allows one of them to be active at a time. On the calendar table side, we always have the DateKey column, which is involved in the relationships, while on the sales table side, we have the DueDateKey, OrderDateKey, and ShipDateKey...