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´m trying to count the number of salespersons that have a fulfillment rate (sales / budget) over 80%. Fulfillment is a measure in my file. I have try with calculate but no success.
Hola a todos,
Estoy tratando contar el número de vendedores que tienen un cumplimiento (ventas/presupuesto) superior al 80%. El cumplimiento lo tengo como una medida dentro de mi archivo.
Hope you can help me
Espero me puedan ayudar
Hi @nicolasmeza1986 ,
Whether the problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help other members in the community find the solution easily if they face the similar problem with you. Thank you.
Best Regards
Rena
Hi @nicolasmeza1986 ,
You can create a measure as below:
Measure =
CALCULATE (
DISTINCTCOUNT ( 'Table'[salespersons] ),
FILTER ( ALLSELECTED ( 'Table' ), [fulfillment rate] > 0.28 )
)
If the measure can't return the correct values, please provide some sample data(exclude sensitive data) and the formula of your measure "fulfillment rate".
Best Regards
Rena
HI @nicolasmeza1986 ,
Can you share some sample data in text format.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi/Hola @nicolasmeza1986
I´m trying to count the number of salespersons that have a fulfillment rate (sales / budget) over 80%. Fulfillment is a measure in my file. I have try with calculate but no success.
Considering you already have the value sales / budget in column as [sales / budget]
Over 80% =
var CALCULATE(COUNT(table[salespersons]),FILTER(ALLEXCEPT(table[salespersons]),table[sales / budget]>80))
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
@nicolasmeza1986 Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |