Forum Discussion
Advocate IIMake a column not sum/count
You need to go back to the table/query click on the dots to the right and select edit query
When the data list is displayed, find the column that you want to sum. right click on the column title to select the column and display the menu, then select "change type" and select the appropriate type such as "decimal number"
Click the "Close and Apply" button to update the query.
Now when you click on the field in the "Values" section you should have all the options
Hello,
I am new to Power BI, so need expert help with the same issue. Earlier I was seeing only Count option, but after following your suggestion, I could see all other options except "Don't Summarize" like Sum, Average, Median etc.
I tried different data types like Decimal, Whole Number, Text and Duration but with no luck.
Could you please help me in finding the "Don't Summarize" option.
Thanks in advance