Forum Discussion
Solved
Getting Wrong Totals With Measure
Folks, I am totally new to Power BI and I am struggling with my first dashboard I have 5 columns that have multiple Text Inputs. I am attempting to count these inputs and display them on cha...
Folks,
Thank you for the input.
I simply went back to the Query, added some Conditional Columns on the Text to get Numeric values.
I then created a measure in PowerBI to add the numbers nad got the correct result when entered into my reports
Thanks for the input and it is a pity I could not resolve with measures only
Hey gerrymouse1
Your field it likely set to aggregate by count or distinct count instead of sum. Check out the link below for more information on this: https://docs.microsoft.com/en-us/power-bi/service-aggregates
If this helps please kudo.
If this solves your problem please accept it as a solution.