re write the following measures as variable

Anonymous ,

Maybe the measure should be like below:

Cumulative Complaint Rate =
VAR Cumulative_Complaints =
    CALCULATE (
        [TotalComplaintswithTrends],
        FILTER (
            ALLSELECTED ( PMS_FINANCIAL_PDS ),
            PMS_FINANCIAL_PDS[Month Start] <= MAX ( PMS_FINANCIAL_PDS[Month Start] )
        )
    )
VAR Cumulative_Sales =
    CALCULATE (
        [TotalSalesTrend],
        FILTER (
            ALLSELECTED ( PMS_TM1_SALES_VOLUME ),
            [Month Start] <= MAX ( PMS_FINANCIAL_PDS[Month Start] )
        )
    )
RETURN
    IF (
        DIVIDE ( Cumulative_Complaints, Cumulative_Sales, 0 ) <> 0,
        DIVIDE ( Cumulative_Complaints, Cumulative_Sales, 0 )

Community Support Team _ Jimmy Tao

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