Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Remove measure total in table

Hi all,

 

I can't seem to remove the total of a measure in a table.

 

The measure calculation = [Debtors - Days Aged] - 30.

 

The measure calculation for the Days Aged measure = DATEDIFF(SELECTEDVALUE(FactDebtors[Document Date]),TODAY(),DAY).

 

0

 

Thanks - really appreciate the help,

Daniel

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Try something like this

    if(isfiltered(Table1[Invoice Date]), DATEDIFF(SELECTEDVALUE(FactDebtors[Document Date]),TODAY(),DAY), blank())

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Anonymous , Try something like this

    if(isfiltered(Table1[Invoice Date]), DATEDIFF(SELECTEDVALUE(FactDebtors[Document Date]),TODAY(),DAY), blank())

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous You can also turn off the totals on the table if you don't need them for any of the other fields, do this in the Vizualizations pane by clicking on the format icon.