Hi, I am fairly new to DAX function. I have an xls sheet where for one specific column called " Test phases" contains multiple values in it seperated by (,) and I have another column as "HP Compliance" that has "Yes or ![79153-excel.png][1]No" values. Now I need to calculate the total count of Hp compliance against each phase. Attached is the xls sheet I am using : I know the excel function that helped me in calculating the count , which is =COUNTIFS('Jan Release'!$D:$D,"ST",'Jan Release'!$E:$E,"Yes") but not sure how to resolve it using DAX, Can anyone help please? [1]: /answers/storage/attachments/79153-excel.png