Need to transfer sum case when from SQL to DAX

Question

Hello,&nbsp;&nbsp;Can you help me to transfer the following statement to power BI from SQL (Google data studio)&nbsp;&nbsp;Sum(case when CONTAINS_TEXT(Status,"Done") then 1 else 0 end)/sum (case when Status is not null then 1 else 0 end)&nbsp;Both columns are strings not numbers.&nbsp;&nbsp;Thanks in advance!&nbsp;&nbsp;&nbsp;

anonymous · Accepted Answer

Hi i belive this could be what you are looking for;&nbsp;&nbsp;&nbsp;Dax&nbsp;=DIVIDE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;COUNTROWS&nbsp;(&nbsp;'Table'&nbsp;),&nbsp;CONTAINSSTRING&nbsp;(&nbsp;'Table'[status],&nbsp;"Done"&nbsp;)&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;COUNTROWS&nbsp;(&nbsp;'Table'&nbsp;),&nbsp;'Table'[status]&nbsp;&lt;&gt;&nbsp;BLANK&nbsp;()&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;BLANK&nbsp;())

Forum Discussion

Need to transfer sum case when from SQL to DAX

2 Replies

Related content

Sorting case

Case Sensitivity

Problem with transfer data for fabric to mysql

Cases per Day Calculation

Assign (Transfer) Ownership