0 Kudos

Do Not Summarize not Working as Expected

Status: Delivered
by Super User on ‎05-24-2018 07:54 PM

I have a simplified adventure works data model.  I have a relationship between the sales table and the customer table


Sales[Customer key] *-1 Customer[Customer key]


The Customer[Customer key] is numeric 


I have set the default summarization for the Customer[Customer Key] to do not summarize


Current Behaviour

Add a new Table to the canvas

Drag the Customer[Customer key] to the values section in the field list

Customer Key is added as "Count of Customer Key"

Expected behaviour: Customer Key is added as a categorical field and the list of customer keys appears down the table.


Ironically, if I drag the Customer[Customer Key] and drop it directly on the Table frame (not the values drop zone), I get exactly the behaviour I expect - the column is added as a list of values.

Status: Delivered
by Moderator v-qiuyu-msft
on ‎05-26-2018 08:09 PM

Hi @MattAllington,


The issue has been reported before internally: CRI 65332331. It's by design now. PG team have plan to fix this but don't have hard ETA now. 


Best Regards,
Qiuyun Yu 

by Vicky_Song Established Member
on ‎05-26-2018 08:10 PM
Status changed to: Delivered
Idea Statuses