Pull Column Values by Count

[CHBIV]

Hello Power Bi Community. I am new and excited to be learning this amazing software.

Question: I have a column like below:

AECOsim

0

0

0

1

3

0

4

2

3

4

2

1

1

I want to be able to pull how many occurences happen with each value, like this:

0 = 4

1 = 3

2 = 2

3 = 2

4 = 2

and so on. I have about 30 of these types of columns to do this to.  Any and all help is appreciated!

Thank you

[anupampandey]

Hi @CHBIV,

I have created a sample table based on your example and I have created a measure COUNT(Table1[AECOsim]).

Plot this on matrix, it gives exactly the same output which you required.

I hope it helps you. If yes please accept it as solution.

Cheers,

Anupam

[CHBIV]

With us new people (comment in general) it would be nice to show screen shots of workflow, or link to video showing process. I am a very visually driven fellow, and just seeing this code, I am not sure what to or how to apply it.

Thank You!

[Vvelarde · Accepted solution]

@CHBIV

Hi. please follow the image. 

[CHBIV]

Thank you ever so much!!! exactly what i am looking for!!!!