How to Summarize a Column on a single Visual / Card

[TylerVono]

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.

[amitchandak]

@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]

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?

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.