It can be useful in complex queries or measures where you need to generate combinations between different columns to use as a filter in other CALCULATE and the filter logic is not linear, so you cannot use a CROSSJOIN (or it would be too expensive to use CROSSJOIN and then FILTER).