Show unique values per customer

[rehman1]

Hello, i want to show the UNique value in a column chart and do a sum on unique value per customer

Imagine this table

CustomerID |  Product  |  Price

1                    Apples          $5

1                    Bananna      $5

1                   oranges        $5

2                   Apples          $10

2                   Bananna        $10

2                   Oranges         $10

what i want to be able to do is to show the price, which in the above case is $5  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. 

is it possible?

Thanks in advance 

[v-piga-msft]

Hi @rehman1 ,

I still have a little confused about your desired column chart. 

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

[Anonymous]

Hello, 

mount the graph normally, simply in the value field of the chart choose the option "Do not summarize"

Best Regards,

JO

[rehman1]

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

[Anonymous]

is not on the drop down , is very similar to this image in this source: 

https://community.powerbi.com/t5/Desktop/quot-Do-not-summarize-quot-missing/td-p/30787

[rehman1]

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