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