Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

combining multiple values for unique users

Hi All,

 

I have 2 columns, userID and platform. The platform indicates whether the logged in via the web or native app. I would like to look at how many userIDs are associated with web only, native only and web&native. Any ideas on how I might do this?

 

Thanks,

Chris

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous

     

    Try this pattern

     

    Native Only =
COUNTROWS (
    FILTER (
        VALUES ( Table1[UserID] ),
        CALCULATE ( DISTINCTCOUNT ( Table1[platform] ), Table1[platform] = "native" )
            > 0
            && CALCULATE ( DISTINCTCOUNT ( Table1[platform] ), Table1[platform] <> "native" )
                = 0
    )
)

     

    WEbOnly =
COUNTROWS (
    FILTER (
        VALUES ( Table1[UserID] ),
        CALCULATE ( DISTINCTCOUNT ( Table1[platform] ), Table1[platform] = "Web" )
            > 0
            && CALCULATE ( DISTINCTCOUNT ( Table1[platform] ), Table1[platform] <> "Web" )
                = 0
    )
)

     

    Both =
COUNTROWS (
    FILTER (
        VALUES ( Table1[UserID] ),
        CALCULATE ( DISTINCTCOUNT ( Table1[platform] ), Table1[platform] = "Web" )
            > 0
            && CALCULATE ( DISTINCTCOUNT ( Table1[platform] ), Table1[platform] = "native" )
                > 0
    )
)

     

1 Reply

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    7 years ago

    Anonymous

     

    Try this pattern

     

    Native Only =
COUNTROWS (
    FILTER (
        VALUES ( Table1[UserID] ),
        CALCULATE ( DISTINCTCOUNT ( Table1[platform] ), Table1[platform] = "native" )
            > 0
            && CALCULATE ( DISTINCTCOUNT ( Table1[platform] ), Table1[platform] <> "native" )
                = 0
    )
)

     

    WEbOnly =
COUNTROWS (
    FILTER (
        VALUES ( Table1[UserID] ),
        CALCULATE ( DISTINCTCOUNT ( Table1[platform] ), Table1[platform] = "Web" )
            > 0
            && CALCULATE ( DISTINCTCOUNT ( Table1[platform] ), Table1[platform] <> "Web" )
                = 0
    )
)

     

    Both =
COUNTROWS (
    FILTER (
        VALUES ( Table1[UserID] ),
        CALCULATE ( DISTINCTCOUNT ( Table1[platform] ), Table1[platform] = "Web" )
            > 0
            && CALCULATE ( DISTINCTCOUNT ( Table1[platform] ), Table1[platform] = "native" )
                > 0
    )
)