How to write better DAX in terms of performance

[Divya904]

Hi Experts,

I have created a measure in DAX as below and is giving me the required output. I am just wondering if there is any efficient way to write this calculation in DAX in terms of performance.

No. Of Successful Calls =

CALCULATE(COUNT(vw_z_m07[interactions]),

FILTER( vw_z_m07, vw_z_m07[business trans. type] = "ZB11"),

FILTER(vw_z_m07, vw_z_m07[current opportunity phase] in {"L50","L53"}),

FILTER(vw_z_m07, vw_z_m07[sales cycle] = "8"),

FILTER(vw_z_m07,vw_z_m07[category code] <> "A2ZSKL03010001"),

FILTER(vw_z_m07,vw_z_m07[category code] <> "A2ZSKL03010002"),

FILTER(vw_z_m07,vw_z_m07[category code] <> "A2ZSKL03010003"),

FILTER(vw_z_m07,vw_z_m07[category code] <> "A2ZSKL03050001"),

FILTER(vw_z_m07,vw_z_m07[category code] <> "A2ZSKL01230001"),

FILTER(vw_z_m07,vw_z_m07[category code] <> "A2ZSKL01240001"),

FILTER(vw_z_m07,vw_z_m07[category code] <> "A2ZSKL01430001"),

FILTER(vw_z_m07,vw_z_m07[category code] <> "A2ZSKL01440001") )

Thanks.

Regards,

[Thejeswar · Accepted solution]

@Divya904,

Did you try something like the one below?

No. Of Successful Calls =

CALCULATE(COUNT(vw_z_m07[interactions]),
FILTER( vw_z_m07, vw_z_m07[business trans. type] = "ZB11" && vw_z_m07[current opportunity phase] in {"L50","L53"} && vw_z_m07[sales cycle] = "8" && ....))