DAX equivalent of SQL query

[writetofaiz]

Hi

I am new to Power BI. Could anyone please tell me the DAX equivalent of 

SELECT [ClientId],CASE WHEN [Status] = 'Success' THEN 'Success' ELSE 'Fail' END 'Status' FROM [NotificationEvent].[dbo].[NotificationEventLog]
WHERE [Status] != 'Success'
GROUP BY [ClientId], CASE WHEN [Status] = 'Success' THEN 'Success' ELSE 'Fail' END

Thanks 

Faiz

[amitchandak · Accepted solution]

@writetofaiz , Create a new column and use with client in visual

New column in DAX

Status = if( [Status] = "Success" , "Success" , "Fail")

refer the series if needed

https://www.youtube.com/watch?v=WlvQ_SGy4iA&list=PLPaNVDMhUXGZNyKU0PgG2g3P0c6CPjMnj