How to resolve a performance issue of my measure

[Anonymous]

Hello,

I have a report with live connection (ssas tabular) I'm facing an issue when i start the report as some calculation up to 1 minute to show up.

After troubleshooting , i find that i have a measure that is slower that another as bellow the definition of my measure :

The measure as below run in 7 s

CALCULATE (
     [NbOrders],
     FactSales[IsValid] = 0
 )

Then i have another measure it takes 48 s

CALCULATE (
     [NbOrders],
     FactSales[IsValid] =1
 )

Why the first measure is faster than another even if it's same with different filter 

Thanks

[Anonymous]

@tamerj1 

As bellow the code of [NbOrders]

CALCULATE (
    [Cnt],
     SUMMARIZE (
        Sales,
        DimProduct[Product_id]
    )
    ,SUMMARIZE (
        Forecast,
        DimProduct[Product_id]
    )
)

The definition of Cnt as bellow :

Cnt :=  DISTINCTCOUNT ( Invoice[CustoID] )

Thanks

[v-chenwuz-msft]

Hi @Anonymous ,

Can you try this code for [NbOrders]:

CALCULATE (
    [Cnt],
    FILTER ( Sales, [Product_id] IN VALUES ( Forecast[Product_id] ) )
)

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tamerj1]

@Anonymous 

can you please share a screenshot of your data model?

[Anonymous]

@tamerj1 

The model is huge and the information is sensitive . Can i do it in private ?

[tamerj1]

@Anonymous 

What is the code of [NbOrders]?