Forum Discussion
Show non aggregated value
Hi my goal is to get the below calculation:
In POWER BI, it's aggregating the rows that's why it's showing 495. Is there a way to create a calculation to show the actual value (not the aggregated) without using aggregated functions.
Hi Anonymous ，
You can achieve it by the following methods, please find the details in the attachment.
1. Don't summarize option
2. Create a column with unique values: add an index column just as suggested by amitchandak or create a rank calculated column just as the one in the below threads
Chart to display actual value instead of aggregate
Best Regards
2 Replies
- amitchandak
Super User
Anonymous , Add an index column in the power query and add that in visual as not summarized column
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
Hi Anonymous ，
You can achieve it by the following methods, please find the details in the attachment.
1. Don't summarize option
2. Create a column with unique values: add an index column just as suggested by amitchandak or create a rank calculated column just as the one in the below threads
Chart to display actual value instead of aggregate
Best Regards
