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/

     

     

d2hughes's avatar
d2hughes
New Member
4 years ago

Yes this looks correct! I made this a simple sample but it should translate to the actual data I am working on.

 

Thank you so much!