Forum Discussion
Not able to avoid aggregation
- Anonymous8 years ago
Nothing was working for me, so what I did was, I created measures with SUMX or any aggregate function and used that measure in the visualization. I also observed that we can just do (+ 0) as the end of a Measure, so that it will convert into numeric column. Hope it helps someone!
Click the little drop down arrow next to the "Count of ..." and see if you have an option of "Don't Summarize" If not, that usually means that you are dealing with a Text field. However, you may not have the option of not summarizing for a guage visualization. Can you share sample data?
Nothing was working for me, so what I did was, I created measures with SUMX or any aggregate function and used that measure in the visualization. I also observed that we can just do (+ 0) as the end of a Measure, so that it will convert into numeric column. Hope it helps someone!
- v-piga-msft8 years agoResident Rockstar
Hi Anonymous,
It seems that you have solved your problem, you could accept your answer making sense as a solution so that people who may have the same question can get the solution directly.
Best Regards,
Cherry