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(SELECT...
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())

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())