Do not Summarise Table Data

[PBIMike]

Hello,

I currently have a list of orders, where, for reasons I won't explain here so as to confuse matters, many order numbers are repeated, eg.

Order/cust            value

1    Cust A                 10

1    Cust B                 10

2    Cust C                 10

3    Cust D                 10

4    Cust E                 10

5    Cust F                 10

5    Cust G                10

The table will only show one row per order number. Order #5 for example would show once as Order #5, Cust F (first record result) and 20 value (total of both records). What I would like the visual to do is show all of the unique order entries, despite they are not all unique identifiers.

Is there an option that does this?

The order number field is a whole number, and is set to do not summarise.

Many thanks,

Mike

[PBIMike]

Sorry, I don't understand. In the example I gave there are 7 unique customers but only 5 unique order numbers. Values in the visual summarise by order number, and only return the first customer result.

Example data:

Order/cust value

1 Cust A 10

1 Cust B 10

2 Cust C 10

3 Cust D 10

4 Cust E 10

5 Cust F 10

5 Cust G 10

Example visual result:

Order                Customer            Value

1                        Customer A          20

2                        Customer C          10

3                        Customer D          10

4                        Customer E          10

5                        Customer F          20

I want the visual to show the detail available in the data, and not summarises repeated orders into a single row. Hopefully I've explained that a bit better but please let me know if it doesn't make sense.

Many thanks,

Mike

[v-easonf-msft · Accepted solution]

Hi, @PBIMike 

In advanced editor,you can try feature "Group by" 

result1:

In Report view, you  just need  to change the sumarize type as below:

result2:

Please check my sample file for more details.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@PBIMike , In all the visual tables same values will not repeat. So you have Add a customer or add an index column and use that is visual https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi