help me optimize the code

[Anonymous]

Hi guys,

This is the DAX I wrote to sum up the successful leads per gender.

Is there another way of calculating it?

I need to calculate it in variables and not with calculated columns (that's easy).

table1 =

var table11 = summarize(

AudienceSelector_vw,

[DCS_sex],

[Club_cnt_successful_leads]

)

var table22=

ADDCOLUMNS(

table11,

"Successful Leads",

calculate(

sum(AudienceSelector_vw[Club_cnt_successful_leads]),

filter(

AudienceSelector_vw,

AudienceSelector_vw[DCS_sex]=EARLIER(AudienceSelector_vw[DCS_sex]))))

return

summarize(

table22,

[DCS_sex],

[Successful Leads]

)

[sevenhills · Accepted solution]

table1 = GROUPBY ( 
       AudienceSelector_vw, 
       AudienceSelector_vw[DCS_sex],
       "Successful Leads",
       SUMX( CURRENTGROUP(), AudienceSelector_vw[Club_cnt_successful_leads])

)

--------------------------------

(or)

--------------------------------

table1 = GROUPBY ( 
       AudienceSelector_vw, 
       AudienceSelector_vw[DCS_sex],
       "Successful Leads",
       SUMX( CURRENTGROUP(), SUM(AudienceSelector_vw[Club_cnt_successful_leads]))

)