how to convert this sql into dax

[Anonymous]

select count(1),tbl_defects_created.Fix version
from rally_report_db.tbl_defects_created
where summary like 'PP%' or summary like 'WR%'
group by tbl_defects_created.Fix version

[Amit2019]

Hi Below is the DAX function -

Table =

SELECTCOLUMNS(

                                          SUMMARIZE(

                                                                     CALCULATETABLE(tbl_defects_created,

                                                                                                      FILTER(tbl_defects_created,

                                                                                                                     OR( SEARCH("PP",tbl_defects_created[summary],1,BLANK()) =1 ,

                                                                                                                             SEARCH("WR",tbl_defects_created[summary],1,BLANK()) =1

                                                                                                                             )

                                                                                                                        )

                                                                                                                   ), 

                                                                                                  tbl_defects_created[fix_version],

                                                                                                 "Cnt",COUNTROWS(tbl_defects_created)

                                                                         ), 

                                                "Fixed_version",tbl_defects_created[fix_version],"Cnt",[Cnt]

                                        )

Thanks,

Amit Dhiman