Ultimate access to all questions.
You have a Fabric tenant containing a semantic model named Model1. You find that the following query executes slowly against Model1.
EVALUATE
SUMMARIZECOLUMNS (
'Product'[Color],
FILTER (
VALUES ( 'Product'[Color] ),
CALCULATE ( COUNTROWS ( 'Order Item' ) ) > 0
)
)
You need to reduce the query execution time.
Solution: Replace line 4 with the following code:
NOT ISEMPTY ( CALCULATETABLE ( 'Order Item' ) )
Does this solution meet the goal?