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
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
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?
Hi @TangiralaDineshReddy-1882
Have you seen the above Answer? Does this help? ... Post back please & Thanks
3 people are following this question.