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.
Member case ID
jim a1
jim a1
jim a1
jim a2
jim a3
bob b1
bob b1
bob b2
sam c1
sam c2
sam c3
Hello Experts
I'd like a measure that will show
Total number of members with 3 and up UNIQUE case IDs, in this case = 2 (jim and sam)
thank you
Solved! Go to Solution.
hi @konijay
try like:
Measure =
VAR _table =
ADDCOLUMNS(
VALUES(TableName[Member]),
"Count",
CALCULATE(DISTINCTCOUNT(TableName[Case ID]))
)
RETURN
COUNTROWS(
FILTER(_table, [Count]>=3)
)
hi @konijay
try like:
Measure =
VAR _table =
ADDCOLUMNS(
VALUES(TableName[Member]),
"Count",
CALCULATE(DISTINCTCOUNT(TableName[Case ID]))
)
RETURN
COUNTROWS(
FILTER(_table, [Count]>=3)
)
LOVE U!
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |