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.
I've got a master list of users with products and some users have multiple products. I need a DAX to calcutale the users who have two editions
I want the DAX to recognize Qty 1, as Chad is the only person to have both Pro and Std
Primary User | Edition |
Chad | Pro |
Dave | Std |
Matt | Pro |
Chad | Std |
Sam | Pro |
Solved! Go to Solution.
Maybe something like:
Measure =
VAR __User = MAX('Table'[Primary User])
RETURN
MAXX(
FILTER(
SUMMARIZE(
ALL('Table'),
[Primary User],
"__Count",COUNT([Edition])
),
[Primary User] = __User
),
[__Count]
)
Maybe something like:
Measure =
VAR __User = MAX('Table'[Primary User])
RETURN
MAXX(
FILTER(
SUMMARIZE(
ALL('Table'),
[Primary User],
"__Count",COUNT([Edition])
),
[Primary User] = __User
),
[__Count]
)
#DoubleEditionUsers = SUMX(SUMMARIZE('Table', [Primary User], "Qty", DISTINCTCOUNT('Table'[Edition] )), IF([Qty] = 2, 1))
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 |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |