How can i write a measure witout Summaize for performance

Yassir 161 Reputation points
2022-06-14T15:52:49.87+00:00

Hello,

I have a measure that use a summarize like as bellow :

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

The definition of the measure Cnt as bellow :

Cnt :=  DISTINCTCOUNT ( Invoice[CustoID] )  

I want to rewrite the first measure without using Summarize to have a best performance .

Any one have an idea how can i do it ?

Thanks for help !

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
340 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,007 questions
{count} votes