Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
In Modelling->New Measure, create a new measure
Measure = CALCULATE(COUNT(Sheet1[status]),FILTER(ALLEXCEPT(Sheet1,Sheet1[principals]),[status]="Won"))
Best Regards
Maggie
Hi,
Drag Principals to the row labels and write this measure
=CALCULATE(COUNTROWS(Sheet1),sheet1[status]="Won")
Hope this helps.
In Modelling->New Measure, create a new measure
Measure = CALCULATE(COUNT(Sheet1[status]),FILTER(ALLEXCEPT(Sheet1,Sheet1[principals]),[status]="Won"))
Best Regards
Maggie
In Fields visualization.
Under Details select, Priciple Name
And under values select Count of Opprtunity.