Count of instances

[ToddMate]

Hi,

I would like a measure that counts the number of times the "Account Number" in the image below occurs.

Then, i would like to show this in a visual (OUTCOME TABLE) in a way that shows the number of times a count of 1,2,3,4,5 etc has occured.

For example, in TABLE A, account Number 15 is shows 3 times so this would show in a visual as 1 in a similar way that all accounts which have a count of 1 total 8 and show as 8.



Hoping someone can assist with this.

Cheers,
Todd

[v-lionel-msft]

Hi @ToddMate ,

Is your measure "Account Number" like this?

Account Number = COUNT(Sheet4[Values])

But I can't understand the relationship between "Account Number" and "Occurence of Accounts".

And I also can't understand What the "Count" column represents.

So please describe in detail the meaning of "Occurence of Accounts" column and "Count" column.
It's better to give me a .PBIX file.

Best Regards,
Lionel Chen

[ToddMate]

Hi @v-lionel-msft 

The only table is Table A and the only column in Table A is Account Number.

The OUTCOME in colum E of the picture is what i am looking to achieve by way of a measure. 

Essentially i am just after a count of the number of times an account number appears. Hence in the example i put Occurance of Accounts and a count of the number of times that the above occured.