Forum Discussion

CHBIV's avatar
CHBIV
Regular Visitor
9 years ago
Solved

Count of Each Value

Hello Power Bi Community!!!

I am new to this software and am excited to learn. Question: I have a column as such (has about 400 entries):

 

AECOsim

0

0

0

1

0

1

2

2

3

4

4

2

 

I want to be able to return something like "there are"

 

0 = 4

1 = 2

2 = 3

3 = 1

4 = 2

 

and so on for this entire column. I have about 30 of these to do this to.......

 

Please help!

 

Thank you in advance :smileyhappy:

 

  • CHBIV

     

    You can create a table visual and drag the AECOsim column into the table twice, and select Count for the second one as below.

     

     

    Best Regards,
    Herbert

1 Reply

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    CHBIV

     

    You can create a table visual and drag the AECOsim column into the table twice, and select Count for the second one as below.

     

     

    Best Regards,
    Herbert