In Matrix table I am geeting slow performance when I am doing drill down. And I am not getting Total

[aamirkhan_WT]

Hi All

In Matrix table I am geeting slow performance when I am doing drill down. And I am not getting Total value for North America as I have turn off the Subtotal for the performance issue. Is there is any solution to improved the performance when I am doing drill down

[aamirkhan_WT]

I am using below 
dax: 

Account_1_M =

VAR _SelectedAccount =

    SELECTEDVALUE ( 'Account_1'[L1] )

VAR Result =

    CALCULATE (

        [_ReportingCycle_Formated_M_AS],

        ALL ( wt_fin_staging_pl_accounts_mapping_sorting ),

        wt_fin_staging_pl_accounts_mapping_sorting[l1]

            IN { _SelectedAccount }

            || wt_fin_staging_pl_accounts_mapping_sorting[l2]

            IN { _SelectedAccount }

            || wt_fin_staging_pl_accounts_mapping_sorting[l3]

            IN { _SelectedAccount }

            || wt_fin_staging_pl_accounts_mapping_sorting[L4] IN { _SelectedAccount }

    )

RETURN

    Result

[amitchandak]

@aamirkhan_WT , For that we have to check the measure you are using