Hi,
It appears that there is a bug in Power BI Desktop (2.49.4831.521 64-bit (August 2017)) whereby the "Do Not Summarize" setting for a field is being set differently depending on whether you tick the box in the field list or if you drag the field in.
If the field is numeric and with the default summarization set to "Sum" then ticking the box appears to work as expected. However, dragging the field in to the "Values" switches the summarization to "Do Not Summarize" and you end up getting every row returned.
I've uploaded a video here showing the behaviour with some very basic sample data:
Any ideas? Can anyone replicate this?
Cheers,
Lee
3 Comments
v-haibl-msftMicrosoft Employee
I can repro the same issue as you. I’ve reported it internally to Power BI Team: CRI 46574704
I’ll post here once I get any update about it.Best Regards,
Herbert
Vicky_SongImpactful Individual
Status changed:NewtoAccepted- v-haibl-msft
I’ve got response from the Product Team.
This is a known issue. We have different code paths for drag vs. checkbox when adding a field due to historical reasons.
We plan to address things like this in a fairly large sized scenario. We won't start on this work until next year though.
Best Regards,
Herbert