Forum Discussion

Postigo's avatar
Postigo
Frequent Visitor
4 years ago
Solved

Using distinctcount as a filter

Hello everyone, here is a issue i'm facing: i have two tables (Products and Sales) and i need to have a measure to show me how many products i have that more than 3 different Clients bought(in ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago
    var Table1 =
    Filter(
    SUMMARIZE(
    'Product',
    'Product'[SK_PRODUCT],
    "teste",DISTINCTCOUNT(Sales[SK_CLIENT])
    ),
    [teste]>3)
     
    )
    return

     

    COUNTROWS(Table1)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

llo

 

Why dont you use the filter ?