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
var Table1 =
Filter(
SUMMARIZE(
'Product',
'Product'[SK_PRODUCT],
"teste",DISTINCTCOUNT(Sales[SK_CLIENT])
),
[teste]>3)
 
)
return

 

COUNTROWS(Table1)
  • Postigo's avatar
    Postigo
    Frequent Visitor
    4 years ago

    Perfect James!!

    Thanks a lot