Removing TOPN DAX

Hello dantheram,

Can you please try this approach:

DEFINE
VAR __DS0FilterTable = 
TREATAS({"In Progress",
"Not Started"}, 'ILR Actions'[Status])
 
VAR __DS0Core = 
SELECTCOLUMNS(
KEEPFILTERS(
FILTER(
KEEPFILTERS(
SUMMARIZECOLUMNS(
ROLLUPADDISSUBTOTAL(
ROLLUPGROUP(
'ILR Actions'[Parent ILR],
'ILR Actions'[Body Plain Text.text],
'User Information List'[Title],
'ILR Actions'[StartDate],
'ILR Actions'[DueDate],
'ILR Actions'[Updates.text]
), "IsGrandTotalRowTotal"
),
__DS0FilterTable,
"OD_Flag", IGNORE('ILR Actions'[OD Flag]),
"CountRowsILR_Actions", COUNTROWS('ILR Actions')
)
),
OR(
OR(
OR(
OR(
OR(
NOT(ISBLANK('ILR Actions'[Parent ILR])),
NOT(ISBLANK('ILR Actions'[Body Plain Text.text]))
),
NOT(ISBLANK('User Information List'[Title]))
),
NOT(ISBLANK('ILR Actions'[StartDate]))
),
NOT(ISBLANK('ILR Actions'[DueDate]))
),
NOT(ISBLANK('ILR Actions'[Updates.text]))
)
)
),
"'ILR Actions'[Parent ILR]", 'ILR Actions'[Parent ILR],
"'ILR Actions'[Body Plain Text.text]", 'ILR Actions'[Body Plain Text.text],
"'User Information List'[Title]", 'User Information List'[Title],
"'ILR Actions'[StartDate]", 'ILR Actions'[StartDate],
"'ILR Actions'[DueDate]", 'ILR Actions'[DueDate],
"'ILR Actions'[Updates.text]", 'ILR Actions'[Updates.text],
"IsGrandTotalRowTotal", [IsGrandTotalRowTotal],
"OD_Flag", [OD_Flag]
)

VAR __DS0CoreNoInstanceFiltersNoTotals = 
FILTER(KEEPFILTERS(__DS0Core), [IsGrandTotalRowTotal] = FALSE)

EVALUATE
GROUPBY(
__DS0CoreNoInstanceFiltersNoTotals,
"MinOD_Flag", MINX(CURRENTGROUP(), [OD_Flag]),
"MaxOD_Flag", MAXX(CURRENTGROUP(), [OD_Flag])
)

EVALUATE
__DS0Core

ORDER BY
[IsGrandTotalRowTotal] DESC,
'ILR Actions'[DueDate],
'ILR Actions'[Parent ILR],
'ILR Actions'[Body Plain Text.text],
'User Information List'[Title],
'ILR Actions'[StartDate],
'ILR Actions'[Updates.text]

Hope this helps.