Forum Discussion
michaeljc70
Advocate II
Advocate IIMake a column not sum/count
I've used Power BI quite a bit lately with a SSAS cube and some Sql Server queries and created many visualiations. I am still fairly new to this though and cannot figure this out. I imported a ...
maracles
Resolver II
Resolver IImichaeljc70 if I understand you correctly you have not created a measure, you are just dragging the columns to the visualisation.
Do avoid the aggregation happening:
1. Find the field in question in the Values field of the Visualisations Pane
2. Click the small arrow to the firght of the column name
3. Click 'Don't Summarise'
Picture below, hope that helps.
Hello,
Thank you for the reponse - it makes a ton of sense. The issue I'm experiencing is there is "Don't Summarize" option.
The options listed are:
- Sum
- Average
- Minimum
- Maximum
- Count (Distinct)
- Count
- Standard Deviation
- Variance
- Median
Thoughts?