Forum Discussion
TylerVono
Helper III
Helper IIISummarize Visual Card on a Single Column for Only Those Shown
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
2 Replies
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
TylerVonoSorry its not working.
