Measure to calculate the sum of distinct count

[Anonymous]

Hi everyone,

I would like to show the sum of distinct count on a column chart. My data looks like this.

What I would like to achieve is a graph that shows the sum of the distinct count of ID for each customer. Here I can show you the summary table and the result chart. Actually, the summary table is not needed. A measure that can calculate the sum of the distinct count of ID for each customer is ok.

Thank you very much for your help.

[ryan_mayu]

@Anonymous 

why the distinctcount for month1 shop1 is 4? could you pls provide the calculation logic?

[Anonymous]

The solution provided by @amitchandak already solved my problem. Thanks for your help anyway ^-^

[amitchandak · Accepted solution]

@Anonymous , you can try like

Countx(summarize(Table, Table[Month], Table[Shop], Table[Customer]),[Customer])

You can add or remove group column from summarize

[Anonymous]

Thanks for your great solution!