Distinctcount with conditions

[BrunoE]

Hello !

I want to calculate the number of buyers who have make more than 100 orders, but in my table i have an order number. When i try to write : calculate(distincount(Vendeur));count(order)>10) i have an error beacuse i use an true/false condition.

Is it possible to calculate that ?

[Anonymous]

Try this:

CALCULATE(
                  DISTINCTCOUNT(
                  VendeurTable[Vendeur]),
                  FILTER(
           OrderTable, OrderTable[order]=>100
           )
                )

It should translate to: Give me the number of distinct text formated values when you filter the OrderTable where the Order column has a value of 100 or more.

[Anonymous]

// Vendor is a dimension storing vendors
// one vendor per row. [Order Count]
// counts orders.

[# Vendors With 10+ Orders] =
	COUNTROWS(
		FILTER(
			Vendor, 
			[Order Count] > 10
		)
	)

Best

D

[Greg_Deckler · Accepted solution]

@BrunoE - Perhaps try 

Measure =
  VAR __Table = 
    SUMMARIZE(
      'Table',
      [Vendeur],
      "Count",COUNTROWS(DISTINCT('Table'[Order]))
    )
RETURN
  COUNTROWS(FILTER(__Table,[Count]>10))

If that is not correct, 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.