Forum Discussion

CHBIV's avatar
CHBIV
Regular Visitor
9 years ago
Solved

Pull Column Values by Count

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

 

:smileyvery-happy:

4 Replies

  • anupampandey's avatar
    anupampandey
    Helper III
    9 years ago

    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's avatar
      CHBIV
      Regular Visitor
      9 years ago

      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!