How can i write a measure witout Summaize for performance

Yassir 201 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.
467 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,307 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.