Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello, I am trying to write a measure that summarizes a single column on a visual table, I tried this measure:
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
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
Sorry its not working.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |