[DAX Optimize] Querying count metric along with few dimension column from Cube takes long time

[abhiram342]

Hi All,

I have couple of Fact and dimension table and trying to query the measure from Fact Table along with few columns from Dimension table but query take long time . Can someone please help 

Fact:

ProductId

ProductCountLocal -- this is Count measure on SalesId with IsLocal =="Yes"

IsLocal

Dimension

ProductId

ProductName

ProductLocation

DAX Code

EVALUATE
SELECTCOLUMNS (
SUMMARIZECOLUMNS (
Fact[ProductId],
Dimension[ProductName],
Dimension[ProductLocation]
"ProductCount",Fact[ProductCountLocal],
),
"ProductId",Fact[ProductId],
"ProductName", Dimension[ProductName],
"ProductLocation", Dimension[ProductLocation],
"ProductCount", [ProductCount]
)

Thanks,

Abhiram

[amitchandak]

@abhiram342 , is this not work alone?

SELECTCOLUMNS (
Fact[ProductId],
Dimension[ProductName],
Dimension[ProductLocation]
"ProductCount",Fact[ProductCountLocal],
)