topic How to resolve a performance issue of my measure in DAX Commands and Tips

How to resolve a performance issue of my measure

Anonymous — Mon, 20 Jun 2022 15:36:41 GMT

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

Re: How to resolve a performance issue of my measure

tamerj1 — Mon, 20 Jun 2022 16:09:39 GMT

Anonymous

What is the code of [NbOrders]?

Re: How to resolve a performance issue of my measure

Anonymous — Mon, 20 Jun 2022 16:40:55 GMT

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

Re: How to resolve a performance issue of my measure

tamerj1 — Mon, 20 Jun 2022 16:51:31 GMT

Anonymous

can you please share a screenshot of your data model?

Re: How to resolve a performance issue of my measure

Anonymous — Mon, 20 Jun 2022 17:14:52 GMT

tamerj1

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

Re: How to resolve a performance issue of my measure

v-chenwuz-msft — Thu, 23 Jun 2022 07:28:50 GMT

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.