Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Show unique values per customer

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 ...
Need Help
Show and Tell
Tips and Tricks
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous ,

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