Forum Discussion

ThomasSan's avatar
ThomasSan
Icon for Helper IV rankHelper IV
4 years ago
Solved

Using filtered value for further calculations

Hi everyone,   I would like to use the total of a table element of a filtered table in a further DAX calculation.   Example:   I would like to use the total of Number of Invoices (here th...
DAX
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Try this (assuming you don't have other table):

    VisualTotal = CALCULATE ( SUM ( Table1[Number Of Invoices] ), ALLSELECTED ( Table1 ) )

     

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

Try this (assuming you don't have other table):

VisualTotal = CALCULATE ( SUM ( Table1[Number Of Invoices] ), ALLSELECTED ( Table1 ) )

 

  • ThomasSan's avatar
    ThomasSan
    Icon for Helper IV rankHelper IV
    4 years ago

    cool, thank you, learnt another important bit of DAX today 🙂