The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Solved! Go to Solution.
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
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
@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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
95 | |
80 | |
62 | |
56 |
User | Count |
---|---|
252 | |
121 | |
112 | |
81 | |
70 |