Forum Discussion

madmanmark198's avatar
madmanmark198
Frequent Visitor
4 years ago
Solved

Remove Total from Column in a Table

Hi all   I have a table with a calculated measure where I am working out the number of days since a particular date  in a column.  Below is my DAX for it.   Days Open = DATEDIFF(MAX('Gift'[date]...
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

madmanmark198's avatar
madmanmark198
Frequent Visitor
4 years ago

Thanks Rohit but this turns of the whole row of totals.  I would still like to show the totals of a number of the other columns I have.  So what I am looking for is the total for that specific column not to show.  Do you know of a way?

rohit_singh's avatar
rohit_singh
Icon for Solution Sage rankSolution Sage
4 years ago

Hi madmanmark198 ,

You could try clicking on the dropdown icon in the column and selecting don't summarize. Maybe that helps?

 


Kind regards,

Rohit

  • madmanmark198's avatar
    madmanmark198
    Frequent Visitor
    4 years ago

    I tried that but its not an option because its a calculate measure.  All I get is the below:

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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