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, nativ...
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
    )
)

     

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