Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 ) )
@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 ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |