In this video, the presenter is exploring different versions of a measure named "has no sales," which checks whether a product has any sales in a given filter context. The goal is to test the performance of these versions and choose the best one for production use. Here are the key points:
- The measure "has no sales" is used to determine if a product has sales or not.
- Various versions of the measure are tested, including:
1. Checking if the sales amount is equal to zero.
2. Counting the number of rows in the sales table.
3. Using the `ISEMPTY` function to check if the sales table is empty.
4. Using the `INTERSECT` function to compare product keys and sales product keys.
5. Using the `EXCEPT` function instead of `INTERSECT`.
6. Using the `IN` operator to check if the product key is in the selected values.
- Performance metrics, including storage engine CPU time, formula engine CPU time, and total execution time, are measured for each version.
- The version using `ISEMPTY` is found to be the fastest, with a total execution time of 1.4 seconds, making it the preferred choice.
The video focuses on performance testing and optimization of this measure in a business intelligence context.
Here are the key facts extracted from the text:
1. The video is about testing the performance of different versions of a measure.
2. The measure is named "has no sales" and checks whether a product has sales or not.
3. There are multiple versions of the measure, including using "sales amount," "count rows," "is empty," "intersect," and "except."
4. Testing performance involves running queries and measuring execution times.
5. The best-performing version so far is "has no sales using is empty," with an execution time of 1.4 seconds.
6. Other versions, such as "has no sales using intersect" and "has no sales using except," have slower execution times.
7. There's a final version that uses the "in" operator and is designed for slicing by one product only.
These facts provide an overview of the content without including opinions or additional details.