Remove Total from Column in a Table

Hi madmanmark198,

Measure expression cant be used as a category to expand records, so the 'do not summarize' option will not appear on this field 'right click' menu.

For your requirement, I'd like to suggest you add an if statement to your expression to check the current row context level to prevent the calculation on the total level.

Days Open =
IF (
    ISINSCOPE ( Table[Category] ),
    DATEDIFF ( MAX ( 'Gift'[date] ), TODAY (), DAY )
)

ISINSCOPE function (DAX) - DAX | Microsoft Docs

Regards,

Xiaoxin Sheng