Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

count total an unique value in a column

Hi everyone,

 

I want to count total a unque value in a column.

 

For example I have this

 

Column 1:     Column 2:

1                    11

1                    11

1                    11

1                    11

0                    5

1                    11

0                    5

0                    5

0                    5

1                    11

1                    11

1                    11

0                    5

1                    11

1                    11

1                    11

 

As you can see the number one occurs 11 times and the number 0 occurs 5 times. I want to see with a formula that 11 and 5 in each row. Can you guys help me out?

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

I allready have the right formula, but thanks for helping

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @Anonymous ,

I'm not so clear for your requirement, can you please explain more about this with some expected result?

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

I allready have the right formula, but thanks for helping

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.