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'[Product Name],
FILTER (
VALUES ( 'Product'[Product Name] ),
NOT ISBLANK (
CALCULATE (
COUNTROWS ( 'Order Item' )
)
)
)
)
You need to reduce the query execution time.
Solution: Replace line 4 with the following code:
ISEMPTY ( RELATEDTABLE ( 'Order Item' ) )
Does this solution meet the goal?