Count deppending on a measure / conteo dependiendo del resultado de una medida

[nicolasmeza1986]

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

[v-yiruan-msft]

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

[v-yiruan-msft]

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

[harshnathani]

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)

[pranit828]

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))

[Greg_Deckler]

@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.