filtering with maximum of sales value by contract (DAX)

[Anonymous]

Hi, I am trying to create a new measure using DAX that will indicate the number of contracts that have a maximum of 10000$ in sales, per example. Can I do it just by filtering the sales amount or the number of contracts value?

thank you

[v-xiaotang · Accepted solution]

Hi @Anonymous 

You can try this, create the measures

Measure = IF(MIN('Table'[sales])>=10000,1)

count = CALCULATE(DISTINCTCOUNT('Table'[contract]),FILTER(ALL('Table'),[Measure]=1))

result

[count] returns 3, containing contract2, contract3, contract5

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

You don't need a measure for that. Use the built in filter functions in the Power BI report.