Show unique values per customer

Question

Hello, i want to show the UNique value in a column chart and do a sum on unique value per customer&nbsp;Imagine this table&nbsp;CustomerID |&nbsp; Product&nbsp; |&nbsp; Price1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Apples&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $51&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Bananna&nbsp; &nbsp; &nbsp; $51&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;oranges&nbsp; &nbsp; &nbsp; &nbsp; $52&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Apples&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Bananna&nbsp; &nbsp; &nbsp; &nbsp; $102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Oranges&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$10what i want to be able to do is to show the price, which in the above case is $5&nbsp; and not as $15 for customer ID having 1. and another thing which i would like to see is when i do a sum on colums i should get $15 and not as $45.&nbsp;&nbsp;is it possible?&nbsp;Thanks in advance&nbsp;

anonymous · Answer

Hello,&nbsp;&nbsp;mount the graph normally, simply in the value field of the chart choose the option "Do not summarize"&nbsp;Best Regards,JO

anonymous · Answer

&nbsp;i dont see the option of "Do not summarize" from the drop down&nbsp;

anonymous · Answer

is not on the drop down , is very similar to this image in this source:&nbsp;&nbsp;https://community.powerbi.com/t5/Desktop/quot-Do-not-summarize-quot-missing/td-p/30787&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

for me the "Do not summarize option is blacked out for some reason

v-piga-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
I still have a little confused about your desired column chart.&nbsp;
What is the unique value?
If you want to calculate the price per customer, you could try the measure below.
sum on unique value per customer = CALCULATE(SUM(Table1[Price]),ALLEXCEPT(Table1,Table1[CustomerID]))
Here is the output.

If you still need help, please share your desired output so that we could help further on it.
Best Regards,
Cherry
&nbsp;

Forum Discussion

Show unique values per customer

5 Replies

Related content

Unique value

Count unique values

Unique values

When values duplicate then green when unique then Red

Combine Rows only keeping unique values