Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |