Who needs numbers?

I’d just like to share a little technique I’ve used to solve a number of different business problems. More than once, using a text, date or boolean field in a measure provides great additional functionality to a Cube or PowerBI data model, and helps users to answer their questions better and¬†more quickly.

Non-Numeric Measures
The values in this Matrix are far more useful than just displaying the value of the most medals won.

The Most Common DAX pattern I use is as follows.

For a far more thorough explanation of the underlying theory and alternative example, I explain the technique in great depth on SQL Server Central.

SQL Server Central Article

I will be presenting a talk in Los Angeles at SQL Saturday #640 on this topic.

Leave a Reply

Your email address will not be published. Required fields are marked *