Efficiently identifying rows with invalid dimension combinations

DAX DAX Calculations
2

@Mark,

Great explanation of the problem, and thanks for posting the PBIX file upfront.

I have changed the category of this post to “Optimization Lab” as it is an absolutely perfect fit for this new initiative.

Paging Dr. @AntrikshSharma to the Lab… :grinning:

  • Brian