Dax help

[sameergupta60]

Dear Team,

attached screenshot showing data with serial no,

when we apply sort to the not awarded column serial no gets changed but I need the serial no from 1 instead of the sort column.

Sample data attached 

My query needs the serial no along with the sort condition not awarded packages come to first & awarded after that with continue

Sr No2	Contract Award Package	Critical / Non Critical	Dwg status (Provided/ Not provided)	BOQ Status(Provided/ Not Provided)	Awarded / Not Awarded
3	Balcony, Common Area & External Lights	Critical	Provided	Provided	Not Awarded
10	Energy Meter	Non Critical	Provided	Provided	Not Awarded
5	FTTH	Non Critical	Provided	Provided	Not Awarded
4	Home Automation	Non Critical	Provided	Provided	Not Awarded
29	Inverter (UPS) - Free Issue Material	Non Critical	Provided	Provided	Not Awarded
6	Video Door Phone	Non Critical	Provided	Provided	Not Awarded
47	A1 & A4 Plumbing	Critical	Provided	Provided	Awarded
49	Aluminium Shuttering  - T1	Critical	Provided	Provided	Awarded
50	Aluminium Shuttering  - T4	Critical	Provided	Provided	Awarded
28	Cables, Mains anad Sub mains	Critical	Provided	Provided	Awarded
45	CP sanitaryware Fixing - Free Issue Material	Non Critical	Provided	Provided	Awarded
15	CTFA	Non Critical	Provided	Provided	Awarded
11	DG - Fress Issue Material	Non Critical	Provided	Provided	Awarded
12	DG Works - Low Side	Non Critical	Provided	Provided	Awarded
38	Door Frame - Free Issue Material	Non Critical	Provided	Provided	Awarded
32	Electrical Switches & Other Fixture Fixing - Free Issue Material	Non Critical	Provided	Provided	Awarded
1	Electrical Works	Critical	Provided	Provided	Awarded
21	External Painting	Critical	Provided	Provided	Awarded
23	Façade - Aluminium Doors & Windows	Critical	Provided	Provided	Awarded
20	False Ceiling	Non Critical	Provided	Provided	Awarded
44	Finishing vendor	Critical	Provided	Provided	Awarded
43	Finishing vendor- A1, EWS	Critical	Provided	Provided	Awarded
7	Fire Alarm & PA	Critical	Provided	Provided	Awarded
35	Fire Door - Free Issue Material	Critical	Provided	Provided	Awarded
18	Fire Fighting - Free Issue Material	Critical	Provided	Provided	Awarded
19	Fire Fighting Works	Critical	Provided	Provided	Awarded
2	Hardscape	Non Critical	Provided	Provided	Awarded
36	Internal Door Shutter - Free Issue Material	Critical	Provided	Provided	Awarded
22	Internal Painting	Critical	Provided	Provided	Awarded
31	Internal Wiring & DB, ONT Box - Free Issue Material	Non Critical	Provided	Provided	Awarded
48	Internal/External Plumbing Works	Critical	Provided	Provided	Awarded
46	Internal/External Plumbing works - Free Issue Material	Non Critical	Provided	Provided	Awarded
39	Joinery Work	Non Critical	Provided	Provided	Awarded
24	Lift Installation	Critical	Provided	Provided	Awarded
25	Light fixtures in common areas & in landscape - Free Issue Material	Non Critical	Provided	Provided	Awarded
26	LT Panel	Critical	Provided	Provided	Awarded
27	LV systems (TV & Telephone Wiring) - Vendor & Free Issue Material	Non Critical	Provided	Provided	Awarded
37	Main Door Shutter - Free Issue Material	Critical	Provided	Provided	Awarded
30	Rising Main - Vendor & Free Issue Material	Critical	Provided	Provided	Awarded
8	Security systems - Boom Barrier & CCTV	Non Critical	Provided	Provided	Awarded
1	Softscape	Non Critical	Provided	Provided	Awarded
9	Solar System	Non Critical	Provided	Provided	Awarded
41	Stone - Free Issue Material	Non Critical	Provided	Provided	Awarded
14	STP - Mechanical Works	Critical	Provided	Provided	Awarded
42	Tiles - Free  Issue Material	Non Critical	Provided	Provided	Awarded
16	Ventillation - Free Issue Material	Critical	Provided	Provided	Awarded
17	Ventillation Works	Critical	Provided	Provided	Awarded
40	Wooden Flooring	Non Critical	Provided	Provided	Awarded
13	WTP - Mechanical Works	Critical	Provided	Provided	Awarded

[v-cgao-msft]

Hi @sameergupta60 ,

Are you trying to sort the visuals by [Sr No2] and [Awarded / Not Awarded]?
If so, you can sort multiple columns by holding Shift + right clicking on the columns name.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Idrissshatila]

Hello @sameergupta60 ,

This a normal act what you're getting, because each serial number is referenced to a record either its awarded or not, so when your the award column, it will show for each record its serial number because each record has its data and the serial number won't change.