Summarize Visual Card on a Single Column for Only Those Shown

[TylerVono]

Hello, I am trying to write a measure that summarizes a single column on a visual table, I tried this measure: 

Expected Inventory $ Reduction for 2023 = SUMX(values('Production Buying Tracker'[Item Number]),[Estimated Inventory Reduction in $])

But it is summarizing the wrong total, it is giving me 1.1Million rather than the correct total: $737,685.

Any suggestions? I attached the download link below.

https://www.dropbox.com/s/qtfc0l2p6wzn6lb/ABC%20and%20MOQ%20Analysis%20-%202023.pbix?dl=0

[Anonymous]

Hi @TylerVono,

It seems like a measure total level calculation issue, you can refer to Greg’s blog to use summarize function and iterator functions to handle this scenario:

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng

[TylerVono]

Sorry its not working.