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

[WaleedBinAfzal]

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.

[Ashish_Mathur]

Hi,

Drag Principals to the row labels and write this measure

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

Hope this helps.

[v-juanli-msft · Accepted solution]

Hi @WaleedBinAfzal

In Modelling->New Measure, create a new measure

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

Best Regards

Maggie

[WaleedBinAfzal]

Hi @v-juanli-msft,

Thanks alot.

[zlokesh]

In Fields visualization.

Under Details select,  Priciple Name

And under values select Count of Opprtunity.