Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |