Forum Discussion

d2hughes's avatar
d2hughes
New Member
4 years ago
Solved

Count of Counts

Hello,   I am going to try this again, last time I posted it was marked as spam. I think it was because it was my first post and I included a link to a sample .pbix from my OneDrive.   I need to ...
Count of Counts
Counting
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi d2hughes 

     

    Try this code to create a new table:

    Table =
GROUPBY(
    SUMMARIZE(
        Visits,
        Visits[ContactID],
        "Visits", COUNTROWS( FILTER( 'Visits', Visits[ContactID] = Visits[ContactID] ) )
    ),
    [Visits],
    "Count of Visitors", COUNTX( CURRENTGROUP(), [ContactID] )
)

     

    output:

     

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

Hi d2hughes 

 

Try this code to create a new table:

Table =
GROUPBY(
    SUMMARIZE(
        Visits,
        Visits[ContactID],
        "Visits", COUNTROWS( FILTER( 'Visits', Visits[ContactID] = Visits[ContactID] ) )
    ),
    [Visits],
    "Count of Visitors", COUNTX( CURRENTGROUP(), [ContactID] )
)

 

output:

 

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

 

 

d2hughes's avatar
d2hughes
New Member
4 years ago

Sorry, I forgot one caveat. I need to be able to slice it by the date column. This table works fine for the whole data set but it is unaffected by a slicer on the base table's date. Any ideas?