Jeffrey Wang shares a few tips to avoid issues with window functions in DAX:
Several people had reported running into errors when trying the window functions on fact tables. Let’s look at an example by first adding a calculated table of three columns to the model that is defined by the following DAX expression, and then, add all three columns to a table visual as shown in Figure 1.
Read on for more. This is an area where expected behavior does differ from what you get with window functions in T-SQL.