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)
Postigo's avatar
Postigo
Frequent Visitor
4 years ago

Hello JamesFr06, thanks for your reply.

I can't do that way, what i need is the number of rows of this solution you shared above, in the DAX example i used i tried to create this example as a variable and use the COUNTROWS() on it, but it doesn't work