Unique count of rows in table in measure

[Anonymous]

Dear All,

I have a table in Power BI. Example below:

I want to build a measure showing the number of customer numbers, which for instance could end up in the following output in power BI:

3 rows do have customer number 1234

2 rows do have customer number 9876

1 rows does have customer number 1000

Name of mwasure in this example: 'Number of customer numbers'

Thanks!

Kind regards,

[Anonymous · Accepted solution]

Hi,
You can create a measure with the definition -> 

Count of Customer numbers = calculate(COUNT(Data[Customer Number]),ALLEXCEPT(Data,Data[Customer Number])) and you can get the required results.

[Anonymous · Accepted solution]

Thanks for your reply, however I dont get an unique count, but still a count of the total number of rows. Any other suggestion?

[Anonymous · Accepted solution]

Thanks for your reply, however I dont get an unique count, but still a count of the total number of rows. Any other suggestion?

[Anonymous · Accepted solution]

Hi @Anonymous ,

As far as I konw, Avantika_Thakur 's code should work in your data model.

Or you can try this code to create a calculated column.

CALCULATE(COUNT(Data[customer number]),FILTER(Data,Data[customer number] =EARLIER(Data[customer number])))

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi,
You can create a measure with the definition -> 

Count of Customer numbers = calculate(COUNT(Data[Customer Number]),ALLEXCEPT(Data,Data[Customer Number])) and you can get the required results.