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 ( 'Order Item'[Order ID] ),
CALCULATE ( COUNTROWS ( 'Order Item' ) ) > 0
)
)
You need to reduce the query execution time.
Solution: Replace line 4 with the following code:
CALCULATE ( COUNTROWS ( 'Order Item' ) ) >= 0
Does this solution meet the goal?