Forum Discussion
"DONT SUMMARIZE" NOT WORKING
Hi Everyone,
I would like to ask a why Power BI associative model isn't getting this.
I have Rate by Process and full price of it.
1) Rate by process is not correct on this first image as it's been summarized. However, Price is correct.
2) If I hit the field option "Do not Summarize", it gets the Rate correct and messes up the price, as you can see below.
Need help please!
Thank you
'Rate by process' has a sigma character next to it - meaning powerbi wants to total and summarize it. I suspect you just changed 'Do Not Summarize' in the field well of the report rather than on the Modelling tab of Data view.
Try this , the sigma should disappear
5 Replies
- HotChilli
Community Champion
Where do the 2 fields come from? We need to see the tables and any relationship between them.
- HotChilli
'Rate by process' has a sigma character next to it - meaning powerbi wants to total and summarize it. I suspect you just changed 'Do Not Summarize' in the field well of the report rather than on the Modelling tab of Data view.
Try this , the sigma should disappear