Matt Allington continues a series on blanking out:
This article is a follow on from last week. I recommend you go back and read the article first if you missed it, but in summary, I want to write a measure (not a calculated column) that will return the median sales of products while excluding the products with blanks (no sales). As I showed last week, this is relatively easy with a calculated column. Here it is again. Remember writing calculated columns first is a great way to visualise the problem you want to solve. It is not a great way to solve most problems (some yes, most, no).
Read on to see how you can solve the problem using DAX Studio.