Forum Discussion
Dax help
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 |
2 Replies
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.
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 TeamIf 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
