Count unique values

[Anonymous]

Hi Guys ,

I am new to Power BI and have a challange -

I have unique Material Code in a Coloumn in a Table . When I am trying to count its giving me a sum of all instances repeated over a period rather than giving me a count of unique count without considering its repetation .

Example

Code        C+1     C+2     C+3

400200      0           0         0

So when I count the instance output is coming as 3 instances while I need the count to be just 1.

Not sure how to Articulate the formulae for the measure 

Kind Regards,

Rahul

[v-cherch-msft · Accepted solution]

Hi @Anonymous

Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.

Regards,

Cherie

[Anonymous]

HI Cherie,

Appologies for the late response was travelling hence could not respond. Your solution worked very well thanks a lot for your help.

Regards,

Rahul

[v-cherch-msft]

Hi @Anonymous

You may try to use DISTINCTCOUNT function as below. If it is not your case,please share your data table.

Measure = DISTINCTCOUNT(Table1[code])

Regards,

Cherie