Forum Discussion

TylerVono's avatar
TylerVono
Helper III
3 years ago

How to Summarize a Column on a single Visual / Card

Hello,

 

Is there a standard measure to just capture a summarize a single column?

I simply want to sum all of Expected Inventory $ Reduction for 2023 in a card or measure.

 

 

Tips and Tricks

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    TylerVono , Ideally when you put that on car visual it should sum.

    If not try a measure like

     

    Sumx(Values(Table[Item Number]), [Expected Inventory $ Reduction for 2023])

    • TylerVono's avatar
      TylerVono
      Helper III
      3 years ago

      Thank you but I dont believe it worked:

      It should calculate to: $737,685, but its saying 1.11Million.

      There are no filters on, any ideas?