Hospital Data Question - NEED HELP ASAP

Hi Anonymous ,

According to my understand , you want to remove the rows when the Outcome is blank or =No Injury Reported and then sort by severity of injury, right?

You could use the following to create a new table:

Table 2 =
ADDCOLUMNS (
    FILTER (
        'Table',
        'Table'[OUTCOME] <> "No Injury Reported"
            && 'Table'[OUTCOME] <> BLANK ()
    ),
    "Flag", SWITCH ( [OUTCOME], "Mild / Minor Injury", 1, "Moderate ", 2, "Major", 3 )
)

Then sort the Outcome column by Flag column

Here is the pbix file.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin