I've tried the below
EVALUATE SUMMARIZECOLUMNS ('Item'[Category],
FILTER(
VALUES ('Item'[Category]),
('Item'[Category] <> BLANK ()
)
)
)
ORDER BY 'Item'[Category] ASC
But I don't want to filter out the null values, I want to replace them, because If I...