Departmentwise min,max salary and count or rows using powerbi

Question

I have table like below

I want to display min(salary),max(Salary) and count(rows) by department wise like below using powerbi measures(Dax).

note
not using group by in transform

• note

**

Answer 1

@Tangirala DineshReddy

In this Excel workbook 4 DAX Measures to get what you want:

Min_Eno

=CALCULATE (  
    MIN ( Table1[eno] );  
    FILTER ( Table1; Table1[salary] = MIN ( Table1[salary] ) )  
)  

Min_Salary

=CALCULATE (  
    MIN ( Table1[salary] );  
    FILTER ( Table1; Table1[salary] = MIN ( Table1[salary] ) )  
)  

Max_Salary

=CALCULATE (  
    MAX ( Table1[salary] );  
    FILTER ( Table1; Table1[salary] = MAX ( Table1[salary] ) )  
)  

Count_Rows

=COUNTROWS(Table1)  

Note: IMHO Min_Eno makes no sense at all from a business point of view. If, for the same [deptno], 2 (or more) Min_Salary equal - see my example with [deptno] = 2 - what's the point?