Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Distinct count overlap

I'm not sure how to being to solve this problem:   I have business data with client IDs and Location names, I've created a table with the location names as a column and a distinct count of clients ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    This will give you a table with common values. Change as per need

     

     

    Table = INTERSECT(ADDCOLUMNS(FILTER(Sales,Sales[Sales Date] >= date(2018,06,30)),"AA",Sales[Sales Date]),ADDCOLUMNS(FILTER(Sales,Sales[Sales Date] >= date(2018,06,29)),"AA",Sales[Sales Date]))

     

     

    Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
    Thanks.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak 

 

I'm not sure how I would use intersect in this case. I don't have 2 tables of data and I want to see the intersect between all of the locations, which are values in a single column.

 

 

Thanks

amitchandak's avatar
amitchandak
Super User
6 years ago

This will give you a table with common values. Change as per need

 

 

Table = INTERSECT(ADDCOLUMNS(FILTER(Sales,Sales[Sales Date] >= date(2018,06,30)),"AA",Sales[Sales Date]),ADDCOLUMNS(FILTER(Sales,Sales[Sales Date] >= date(2018,06,29)),"AA",Sales[Sales Date]))

 

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.