Forum Discussion
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)...
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.
// 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