combining multiple values for unique users

[Anonymous]

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

[Zubair_Muhammad · Accepted solution]

@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
    )
)