How can I get the same in Dax

[_PankajGupta]

Select * from Employess where Role = 'Developer'

AND Salary > ALL (Select Salary from Employees where Role = 'Manager');
Sample Table

Employees
id	name	salary	role
1	A	10000	Developer
2	B	10000	Manager
3	C	20000	Developer
4	D	40000	Manager
5	E	50000	Developer

[devanshi · Accepted solution]

Employee Salary = FILTER('Employee' , 'Employee'[Role] = "Developer" &&  'Employee'[Salary] >
                                                      MAXX ( FILTER('Employee' , 'Employee'[Role] = "Manager" ),

                                             'Employee'[Salary])

                                          )

[_PankajGupta]

Is it possible using measure.? 

[devanshi]

Yes , it will work .