cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## How to Use Count for getting total from one column against other column?

Hi All,

I am new to power bi and need some help. I have a table of opportunities in which one column has name principals and one is with name status of the opportunity having values like Won, Lost, Open. Now i want to get the total count of Won Opportunities against each principal. How can i do this? Any help would be highly appreciable.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support

## Re: How to Use Count for getting total from one column against other column?

In Modelling->New Measure, create a new measure

`Measure = CALCULATE(COUNT(Sheet1[status]),FILTER(ALLEXCEPT(Sheet1,Sheet1[principals]),[status]="Won"))`

Best Regards

Maggie

4 REPLIES 4
Member

## Re: How to Use Count for getting total from one column against other column?

In Fields visualization.

Under Details select,  Priciple Name

And under values select Count of Opprtunity.

Community Support

## Re: How to Use Count for getting total from one column against other column?

In Modelling->New Measure, create a new measure

`Measure = CALCULATE(COUNT(Sheet1[status]),FILTER(ALLEXCEPT(Sheet1,Sheet1[principals]),[status]="Won"))`

Best Regards

Maggie

Frequent Visitor

Super User IV

## Re: How to Use Count for getting total from one column against other column?

Hi,

Drag Principals to the row labels and write this measure

=CALCULATE(COUNTROWS(Sheet1),sheet1[status]="Won")

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com

Announcements

#### Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.