Forum Discussion

BrunoE's avatar
BrunoE
Regular Visitor
6 years ago
Solved

Distinctcount with conditions

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 ?

 

 

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    // 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.