question

Yash-1748 avatar image
0 Votes"
Yash-1748 asked DSPatrick answered

How to perform conditional calculation in powerBi

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

not-supported
excel.png (35.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered

Power Bi is not currently supported here on QnA. The product group for Power Bi actively monitors questions over at
https://community.powerbi.com/

--please don't forget to Accept as answer if the reply is helpful--




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.